| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add "left align across selection" cell formatting | Excel Worksheet Functions | |||
| Combo Box selection to place $0 into another cell | Excel Discussion (Misc queries) | |||
| Line selection from a cell script through a VBA macro | Setting up and Configuration of Excel | |||
| Cell selection problem | Excel Discussion (Misc queries) | |||
| Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
Linear Mode
