sujittalukde
02-01-2008, 06:12 AM
I have two macros in a standared module say named Sub test() and Sub check()
In sheet1, I have attached two command buttons and named command button1 as “Tst” and commandnutton2 as “Chek”
Code for cmdbtn1 is
Private Sub CommandButton1_Click()
Call test
End Sub
Code for cmdbtn2 is
Private Sub CommandButton2_Click()
Call Check
End Sub
I want place one command button on Sheet1
When the btn will be clicked with the caption “Tst” for once it will run “test” and the caption will change to “Chek”
If the caption is “Chek” then run Check and then to change the caption to “tst”
In sheet1, I have attached two command buttons and named command button1 as “Tst” and commandnutton2 as “Chek”
Code for cmdbtn1 is
Private Sub CommandButton1_Click()
Call test
End Sub
Code for cmdbtn2 is
Private Sub CommandButton2_Click()
Call Check
End Sub
I want place one command button on Sheet1
When the btn will be clicked with the caption “Tst” for once it will run “test” and the caption will change to “Chek”
If the caption is “Chek” then run Check and then to change the caption to “tst”