Thread: Command Buttons
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ranswrt ranswrt is offline
external usenet poster
 
Posts: 191
Default Command Buttons

I turn the buttons on and off with different procedures on the userform. i
was wondering in there was an event procedure that would make sure that only
one button was on at a time.

"Norman Jones" wrote:

Hi Ranswrt,

You have not indicated how the first
CommandButton is enabled or disabled,
but try something like:

Me.CommandButton2.Enabled = _
Not Me.CommandButton1.Enabled = True

Perhaps it would be possible to provide
more specific help if you were to explain
the enabling mechanism or the purpose
of the excercise.



---
Regards.
Norman
"ranswrt" wrote in message
...
How would I make a commandbutton in a form 'enable=False' whenever another
commandbutton 'enable=True'?