UserForm Button...after click ???

[gene_sc]

Hi another newbe question
I have a userform and would like to have the buttons after they have been clicked to be "grayed out" IE: not enabled.
Would I set this up as a "on Mouse up event"?? could the code be as simple as
On Mouse up enabled =false"

thanks
regards gene

 

[Andrew Poulsom]

Try this:

Private Sub CommandButton1_Click()
    CommandButton1.Enabled = False
End Sub

 

[gene_sc]

Thanks :^)
I'll give it a try, when I get home,
couple of questions....
I aready have a button click event that runs a maro, after the maco runs I want the button enabled state to be false, as in your example. So how do I incorporate your example??
thanks again
regards gene

 

[Andrew Poulsom]

Like this?

Private Sub CommandButton1_Click()
'   *** Call your macro here ***
    CommandButton1.Enabled = False
End Sub

 

[gene_sc]

Yep just like that- being new to Excell & VBA, I wasn't sure of the proper syntax
Thanks
regards gene