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
.
|