cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community email notifications are disrupted. While we are working to resolve, please check on your favorite boards regularly to keep up with your conversations and new topics.

Adding a Button (for Ctrl + F9)

ptc-4476859
1-Newbie

Adding a Button (for Ctrl + F9)

Hello!!

Add button

What is the Code equivalent for Cltr+F9 to be placed in my “Sub PushBtnEvent_Start()” procedure, see below:

Dim state

Sub PushBtnEvent_Start()

Rem TODO: Add your code here

End Sub

Sub PushBtnEvent_Exec(Inputs,Outputs)

Outputs(0).value = state

End Sub

Sub PushBtnEvent_Stop()

Rem TODO: Add your code here

End Sub

Sub PushBtn_Click()

If state = 0 Then

state = 1

Else

state = 0

End If

PushBtn.Recalculate()

End Sub

thanks!!

1 REPLY 1
RichardJ
19-Tanzanite
(To:ptc-4476859)

The Start and Stop procedures are essentially obsolete. You should ignore them.

You are probably looking for the Worksheet.Recalculate method. What exactly are you trying to do?

Top Tags