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" <(E-Mail Removed)> wrote in message
news:E1EB2769-F5B7-4E20-831B-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:5CAEEA58-F8A6-4759-A917-(E-Mail Removed)...
>> > 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.
>>
>>
>>
Similar Threads
