Cell Selection
 

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 ?

--
Thanks,

Saboto

Cell Selection
 

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" wrote in message
...
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 ?

--
Thanks,

Saboto

Cell Selection
 

Is this what you're after?

http://tinyurl.com/frk2s


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532588

Cell Selection
 

Hello Bob,

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

--
Thanks,

Saboto


"Bob Phillips" wrote:

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" wrote in message
...
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 ?

--
Thanks,

Saboto

Cell Selection
 

Hello John,

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

--
Thanks,

Saboto


"John James" wrote:


Is this what you're after?

http://tinyurl.com/frk2s


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532588

Cell Selection
 

Thanks for the feedback


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532588