JLG,
I have a question for you about your statement on routinely not providing
facilities for what I've described.
I tested a UDF earlier and found that the colored selection boxes appear
there as well as on worksheet functions.

Since the UDF is a custom function, what is happening there that allows the
colored outline-selection boxes that we cannot obtain using a RefEdit?

My point being that I find it interesting that one can build a UDF, and
obtain the same results as a standard worksheet function, but in using a
RefEdit we cannot obtain the desired result.



"JLGWhiz" wrote:

RefEdit is a built in facility. VBA does not routinely provide facilities to
modify (expand) the properties of built in functions and dialog boxes.

"SteveDB1" wrote:

I've created a user form.
I have one last "bug" that I need resolved.

For further explanation, when we place a worksheet function in a worksheet,
when a range, or cell is chosen, it's "highlighted" by a colored outline of a
box for that range of cells. If one chooses a series of individual cells,
there are multiple colored boxes.

This is what I was looking for, so that the user could keep clear what
they'd chosen while going through the user form.

Is there a means that I can have these colored outlines, on the worksheet
while I'm selecting ranges for each of my RefEdit elements? If so, how? Is
this located in the properties box of each RefEdit element?

I have looked through the properties of RefEdit, and found HideSelection. I
set it to false, and this does not resolve my issue.



Again-- thank you for your helps.
Best,
SteveB.