About Us

ranswrt

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Command Buttons	Command Button Calculations	Excel Discussion (Misc queries)	4	May 25th 10 06:51 PM
Command Buttons	Hoyas07	Excel Discussion (Misc queries)	2	February 11th 08 03:42 PM
Command buttons	Craig[_8_]	Excel Programming	4	February 8th 04 03:56 AM
Control Buttons vs. Command Buttons	Robert Gibson	Excel Programming	1	October 13th 03 04:33 PM
Command buttons not available	Donna Brooks	Excel Programming	0	August 25th 03 04:23 PM

Menu

About Us