Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting ranges with a text box
Bob,
You can add a UserForm and set it's ShowModeal to False. This will allow the user to copy from cells while the form remains open. -----Original Message----- I am trying to duplicate the functionality of the inputbox with a type =8. (Setting type to 8 allows the user to select a range of cells on a worksheet using the mouse while the dialog box remains on top). I am trying to allow the user to input a range into a text box by selecting a range of cells using the mouse. I am trying to do this by duplicating the functionality of the inputbox with a type =8. (Setting type to 8 allows the user to select a range of cells on a worksheet using the mouse while the dialog box remains on top). This code will show the functionality I am trying to duplicate. Set mycell = Application.InputBox( _ prompt:="Select the range of cells.", Type:=8) I would use this code as is except I have other items I want to add to a dialog box. Thanks, Bob . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting ranges with a text box
Thanks for your help. This works for cutting and pasting data into a textbox, but I was hoping to have the address of the range input automatically when I selected it on a worksheet, similar to the inputbox control with type=8. It appears that refedit will work, although it does look a bit different than the inputbox dialog box. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting mutliple ranges | Excel Worksheet Functions | |||
Selecting Variable Data Ranges | Excel Discussion (Misc queries) | |||
selecting 2 ranges, 1 Worksheet, printing on 1 page PDF | Excel Discussion (Misc queries) | |||
Trouble with selecting multiple ranges of data | Excel Worksheet Functions | |||
selecting ranges | Excel Programming |