Button Macro and Font

[x65140]

Two buttons -sort by number, sort by name
When the button is clicked, I also want to change the properties (i.e. change the font to bold - or maybe even change the font)

I'm sure it's very simple, but I couldn't find an example

I've attached a sample.

[dominicb]

Good evening x65140

I'm sure it's very simple, but I couldn't find an example

You're right - it is very simple. It just can't be done using Form controls like you have.
You will need to use ActiveX controls - still in the Developer > Insert tab, they just allow far more control.

HTH

DominicB

[x65140]

Thanks Dominic.....so I changed to the ActiveX and I can see the properties...
but how do i assign (font, bgcolor, etc...) depending on when it is clicked or not?

(uploaded new file)

[dominicb]

Hi x65140

Take a look at your workbook - I've added two lines to each routine. See if it works how you wanted.
I've also taken the code out of the macro module - it's no longer needed now that the code is in the workbook module.

HTH

DominicB

[x65140]

Excellent! That will get me going...Thanks!

So much to learn......so little time......