PDA

View Full Version : Colour Of Selected Option



HTSCF Fareha
11-29-2022, 03:41 AM
I was wondering if there is a way to change the default selected colour of an OptionButton from black? I can change the background colour behind the text, but cannot see a way of changing the actual colour of the selected option.

Thanks!

HTSCF Fareha
12-06-2022, 06:59 AM
I've been trawling the internet without any luck, so am resigned to the fact that this is not possible.

I'm now checking to see if the colour behind the black dot can be changed, but to be honest, I doubt that this is possible either.

Aussiebear
12-06-2022, 03:02 PM
Did you by any chance look at this Change Option Button forecolor | MrExcel Message Board (https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&ved=2ahUKEwia2_CK7-X7AhVHgFYBHQeuCxwQrAIoAnoECAoQAw&url=https%3A%2F%2Fwww.mrexcel.com%2Fboard%2Fthreads%2Fchange-option-button-forecolor.1185091%2F&usg=AOvVaw0UAhKbDgICwqOyYz_3k0kA) where the fore colour was changed? The intent here was to show if an Option button had been used by changing its colour once it had been selected. Surely from this you can see that it may well be possible. To suggest you have scoured the internet with no luck, implies that you need to change your search engine.

HTSCF Fareha
12-07-2022, 02:07 AM
I had seen this one, thanks.

The ForeColor option only changes the colour of the text of the selected option and not the actual selector. In web design this can easily be changed, but was wondering if the same could be true for VBA, similar to this as shown on the left.

30367