Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons
How would I make a commandbutton in a form 'enable=False' whenever another
commandbutton 'enable=True'? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons
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'? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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'? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons
I'd suggest you just use two subs
Private Sub Button1_On() Me.CommandButton2.Enabled = False Me.CommandButton1.Enabled = True End Sub Private Sub Button2_On() Me.CommandButton1.Enabled = False Me.CommandButton2.Enabled = True End Sub that you call from the "different procedures", e.g.: Private Sub UserForm_Initialize() 'Stuff here Button1_On End Sub Private Sub CommandButton1_Click() 'Do more stuff Button2_On End Sub Private Sub CommandButton2_Click() 'Do even more stuff Button1_On End Sub In article , ranswrt wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons
Thanks i think that will work
"JE McGimpsey" wrote: I'd suggest you just use two subs Private Sub Button1_On() Me.CommandButton2.Enabled = False Me.CommandButton1.Enabled = True End Sub Private Sub Button2_On() Me.CommandButton1.Enabled = False Me.CommandButton2.Enabled = True End Sub that you call from the "different procedures", e.g.: Private Sub UserForm_Initialize() 'Stuff here Button1_On End Sub Private Sub CommandButton1_Click() 'Do more stuff Button2_On End Sub Private Sub CommandButton2_Click() 'Do even more stuff Button1_On End Sub In article , ranswrt wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Command buttons | Excel Programming | |||
Control Buttons vs. Command Buttons | Excel Programming | |||
Command buttons not available | Excel Programming |