| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
| Call an Access macro from an Excel macro | Excel Discussion (Misc queries) | |||
| Excel Macro call Word Macro with Parameters | Excel Programming | |||
| How do I get an OLEObjects check box to call a function when click | Excel Programming | |||
| API call to check other program is idle | Excel Programming | |||
Linear Mode
