| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User selects a range
Excel help says that Excel 97 does not support modeless
userforms. Is there another way that I can have a user select a range through a userform (that is compatible with both Excel 97 and Excel 2000)? Any help would be greatly appreciated, Wesley |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User selects a range
You can put a refedit control on the form. When the control has focus,
the user can navigate and select a range. In article , "Wesley" wrote: Excel help says that Excel 97 does not support modeless userforms. Is there another way that I can have a user select a range through a userform (that is compatible with both Excel 97 and Excel 2000)? Any help would be greatly appreciated, Wesley |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User selects a range
Wesley,
Use the RefEdit control. They allow a user to specify, but not select a range. Rob "Wesley" wrote in message ... Excel help says that Excel 97 does not support modeless userforms. Is there another way that I can have a user select a range through a userform (that is compatible with both Excel 97 and Excel 2000)? Any help would be greatly appreciated, Wesley |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort by name when user selects name on another worksheet | Excel Discussion (Misc queries) | |||
| cursor selects more than one cell range | Excel Discussion (Misc queries) | |||
| Need an input box when user selects a value in a drop down box | Excel Worksheet Functions | |||
| Start Macro after user selects a choice from a pick list | Excel Discussion (Misc queries) | |||
| msgbox prompt when user selects data from combo box | Excel Programming | |||
![Wesley[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
