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.

What you got is what you get.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dileep T M" wrote in message
...
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.

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" wrote:

What you got is what you get.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dileep T M" wrote in message
...
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.

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dileep T M" wrote in message
...
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" wrote:

What you got is what you get.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dileep T M" wrote in message
...
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.