Make buttons active or inactive

Hi,

I want to make a button on my userform to appear active when a certain cell has a certain value and appear inactive if not.

What code can I use?

Hi snb,

You quote:"Avoid using VBA-code you do not understand"

I do not understand exactly what ypur code commandbutton1.enabled=sheets(1).cells(1,5)=12 means.

Please could you explain it to me

Thank you

Hi snb,

Forget about it. I figured it out, thank you! That is a very nice shortcut way of coding instead of referencing specific individual cell addresses by using range, quotes, brackets, etc.