| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RefEdit does not behave like Excel's built-in reference edit boxes
1) Hold down Ctrl
-----Original Message----- I am using the RefEdit control in a number of Excel VBA macros. However, I am unhappy with this control since it does not behave the same as the reference edit boxes that are built into Excel. Specifically: 1. It is difficult for the user to enter multiple, discontiguous cell regions (areas), such as: "A1,B3". Excel typically allows the user to click on A1, type a comma, and then click on B3. However, if this is done with the RefEdit control, then B3 will OVERWRITE (rather than append to) A1, simply returning the range "B3". This has been very disruptive for users. The only workaround (that we've found) is to force the user to enter multiple cell ranges in by hand. ugh. 2. RefEdit quyalifies all cell ranges with the sheet name, even if it's the active sheet, such as: "Sheet1!A1". 3. The icon for the RefEdit collapse button (used to collapse the UserForm down to the size of the RefEdit box) is different than the ones built into Excel, further giving the appearance of an inconsistent GUI. What are the workarounds to these limitations and inconsistencies? Is there a better control that I should use instead of RefEdit? Any assistance would be greatly appreciated. Chris Russell . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Previous Worksheet Built-in Function | Excel Worksheet Functions | |||
| Pie chart built in 2000, now in 2003 but unable to edit 2003-way | Excel Discussion (Misc queries) | |||
| Edit Built in Footer | Excel Discussion (Misc queries) | |||
| Built in message boxes | Excel Discussion (Misc queries) | |||
| Built in message boxes | Excel Discussion (Misc queries) | |||
![Dave Ramage[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
