Skip to main content
1-Visitor
July 12, 2013
Question

Adding a Button (for Ctrl + F9)

  • July 12, 2013
  • 1 reply
  • 931 views

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

19-Tanzanite
July 12, 2013

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?