User change background colour of ActiveX Combo Box

[Yoepy]

I have a need for the user to be able to change the colour of the background on an ActiveX Combo Box. There are about 20 Combo boxes on the sheet.

My preference would be for there to be a colour palette of say, 12 colours, that the user could choose from.
Double click the colour of choice and then click the particular ActiveX combo box and the background would change colour.

Does anyone think this could be done.

Thank you

Yoepy.

[Marc L]

Why not using directly what Excel offers so w/o VBA ?!

[AliGW]

Ooh, you are such a tease, Marc!

Why not share the way to do this without VBA? I think it fair to assume that the OP does not realise what you know, otherwise they'd be using your method already.

More information, please. Thanks.

[Yoepy]

I'm not talking about changing the colour once. I want the user to be able to colour code based on their circumstances. The Combo box is protected and the user is inexperienced.

Using the properties is completely impractical. Sorry I asked.

[AliGW]

Don't apologise - you have nothing to apologise for. Just hang on in here - someone with VBA skills will come along and help soon, I'm sure.

[Marc L]

Oh ♪ come on Eileen ♫ !

If helpers can't ask any question so many threads without solution …

And I forgot to mention that is not such a great idea to use ActiveX instead of Forms Controls !

[AliGW]

We all ask questions to elicit more information in order to be able to help and move a thread forward. Your question was not that type of question.

Given that your response implies that you know how this can be done, I would have expected you to do one of the following:

1. Explain HOW this can be done WITHOUT VBA.
2. Explain HOW this can be done WITH VBA (with the caveat regarding ActiveX).

The response you gave did not move the thread forward in any way. It's not the first time you've responded in this way or been asked to give more detail.

I am not at all surprised at the OP's reaction to your response.

[Marc L]

Ma douce Ali,

according to post #4 the OP already knows how to do it directly under Excel.

According to the poor initial post there is not enough 'material' to help without questions
and as I won't try to guess anything, a bit like « no arm, no chocolate ! » …

And as it's well known ActiveX can be a mess, it's 'safer' to use Forms control.

But I'm sure another helper will post a generic code the OP will have to amend to fit his need …

[AliGW]

Yes, I am sure that another VBA expert will offer the help he/she needs.

[Yoepy]

Can't change font size on Forms control Combo Box. Font is way too small for the application.

[Marc L]

Yes some Forms controls are limited but always work, no surprise between computers, OS versions, Windows update, …

[torachan]

give the attached a trial - double click in a combobox to select - a colour swatch will appear - click on colour - combobox background should change.
code needs tidying up but the basics are there.
torachan.

[Yoepy]

Absolutely perfect!!!

Exactly what I wanted.

I really appreciate your input torachan.

[AliGW]

Glad you got the help you were looking for.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[torachan]

thanks for the feedback.
glad to have helped.
torachan.