View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Check Box to call Macro

Could someone help me understand why if I click my check box it doesn't call
or run my macro... here is the code.

Private Sub CheckBox1_Click()
If CheckBox = True Then
Application.Run "Bond Price Calculator.xlt!GovtClick"
'or call GovtClick
Else: End
End If
End Sub