Colored arrows

[anonymousA]

Hi

Does anyone know how to color the arrow of a combobox (ActiveX) like Excel
does when using the dropdowns of an autofilter selection for filtered ranges
?
I know there's no way achieving my request by the classical instructions of
VBA. Maybe using the API ?

I'm interested in all your answers.

Thanks a lot

 

[Guest]

Good question - I don't know any way to change it and yes, you might need an
API call to do that, if even that is possible... but maybe you could cheat.
Don't know, haven't tried it, but you could maybe create your own command
button and place it exactly over the Combobox button - use VBA code to both
activate and set focus to the combobox dropdown and change the picture on the
buttonfrom a black arrow to a blue one. Seems it could be done with a little
creative effort - if I had the time I would give it a try just for fun! Save
it as a new class...

 

[anonymousA]

Thanks for your answer. In fact, you're right that it could be fun cheating
on this.
But I hoped there was something else. Maybe it's impossible.

So long