View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default Check Box to call Macro

John,

In your code, change "CheckBox" to "CheckBox1":

CheckBox1 = True Then

hth,

Doug

"John" wrote in message
...
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