Change refedit control image

[Dileep T M]

How to change the image in the refedit control?
Instead of that Ugly dash icon can i use another icon like the refedit icon
in function arguments dailog in Excel.

 

[Jon Peltier]

What you got is what you get.

- Jon

 

[Dileep T M]

when you put a refedit control in a form, it wll have a small dashed button
at the right most end of the control. My requirement is that i need to change
or put one icon over that dashed button. For ex. u can refer the Microsoft
Excel, in which in many palces they are using this. For more clarity pls
check "Function Arguments" dialog..

 

[Jon Peltier]

I know what you're asking. The RefEdit control that is available to use on
UserForms is different from the similar edit box used in Excel's built-in
controls. You could place an image over the little icon, but you'd have to
handle the clicks through the image to the icon below. I'm also not sure the
shape would follow the RefEdit when the form collapses to just the RefEdit
while the user selects a range.

It seems more trouble than it's worth. What is wrong with using the plain
RefEdit?

- Jon