Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Start a Macro by physically checking a check box?
I have created my first macro (don't laugh) and I want the macro to start
when I check off a check box in the form I made. How do I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Start a Macro by physically checking a check box?
hi
try this...... Private Sub CheckBox1_Click() If Me.CheckBox1.Value = True Then Call myfirstmacro End If End Sub change any names if needed. regards FSt1 "Mr Imnotabrainsurgeon" wrote: I have created my first macro (don't laugh) and I want the macro to start when I check off a check box in the form I made. How do I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Start a Macro by physically checking a check box?
If you'e written your macro you can right click your checkbox and assign the
code to it (Forms checkbox) then add this as the first line of your sub Sub YourSub() If ActiveSheet.CheckBoxes("Check Box 1").Value = xlOff Then Exit Sub 'Your code End Sub Mike "Mr Imnotabrainsurgeon" wrote: I have created my first macro (don't laugh) and I want the macro to start when I check off a check box in the form I made. How do I do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Start a Macro by physically checking a check box?
when you're in design mode, making changes to the userform, double-
click on the checkbox you want to call the macro. this will open the VB editor & you will see something like: Private Sub Checkbox1_Click() ***** End Sub except there won't be any stars there. where the stars are, that's where you code goes. if your code is in a module in the project or in the userform module you simply write: Call MyCode '<--- change to the name of your code and it will make that code run. :) susan On Sep 24, 3:18*pm, Mr Imnotabrainsurgeon <Mr wrote: I have created my first macro (don't laugh) and I want the macro to start when I check off a check box in the form I made. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to check if a date falls within a range(2 cells: Start/End Dat | Excel Worksheet Functions | |||
macro checking | Excel Worksheet Functions | |||
Checking macro | Excel Discussion (Misc queries) | |||
check if the text string start with a specific character | New Users to Excel | |||
Why does spelling check close Excel when checking spanish? | Excel Discussion (Misc queries) |