Thread: Colored arrows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default Colored arrows

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

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