Cell Selection

[Saboto]

Hello Folks,

Please, I need help ... I have developed a UserForm that has a field (Text
Box) where I put the range of cells I need in my code (example: B1:B15)... Is
there any way to able the form (text box) to accept the mouse selection,
i.e., I select the range through mouse like any kind of "formula" in excell
environment ?

 

[Bob Phillips]

Look at the RefEdit control. It is an additional control on the toolbox,
named RefEdit Ctrl.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[John James]

Is this what you're after?

http://tinyurl.com/frk2s

 

[Saboto]

Hello Bob,

thank you very much ... it is running 100% !

--
Thanks,

Saboto

Look at the RefEdit control. It is an additional control on the toolbox,
named RefEdit Ctrl.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Saboto]

Hello John,

Thanks for your help ... I will try it too !

 

[John James]

Thanks for the feedback