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

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

Check Box to call Macro
 

Thats a little embarrising... THANKS!

"Doug Glancy" wrote:

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