Posted to microsoft.public.excel.programming

Mike H.

external usenet poster

Posts: 471

Toggle Event - 2 Commands on 1 Button

I think this is what you wish to do (This is the code behind a button):

Private Sub CommandButton2_Click()
If CommandButton2.Caption = "Second Step" Then
CommandButton2.Caption = "First Step"
Call SecondStep
ElseIf CommandButton2.Caption = "First Step" Then
CommandButton2.Caption = "Second Step"
Call FirstStep
End If
End Sub

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Command button to toggle worksheet event code on / off?	Fred[_2_]	Excel Discussion (Misc queries)	15	July 31st 07 11:50 AM
Sub() calling Sub()'s in the "worksheet event code€ passing toggle	CRayF	Excel Programming	2	September 25th 05 03:48 AM
Adding .xla button for Toggle Calculation Button	Mike	Excel Programming	5	August 19th 05 01:55 PM
commands button	pts	Excel Programming	1	June 24th 05 08:05 AM
toggle button & event code	Bob Umlas[_3_]	Excel Programming	0	April 14th 05 08:22 PM

All times are GMT +1. The time now is 09:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us