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

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

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


"K Dales" a écrit dans le message de
news: ...
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