Ticking a check box when a macro has run

Booney

New Member
Joined
Aug 2, 2004
Messages
32
Hi there,

I have a few macros that do seperate things on a front page and by each one there is a check box. I was wondering that if there is a way of tying some coding into each macro, that when the macro has been run it automatically ticks the check box, is this possible???

Many thanks in advance
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

tyders

New Member
Joined
Feb 3, 2005
Messages
40
when you record your macro couldnt the final stage be to tick the box, then click stop recording.?
 

Booney

New Member
Joined
Aug 2, 2004
Messages
32
This doesnt work, it doesnt record you ticking the box. I tryed that option already.
Any other ideas anyone?
 

gedi

Board Regular
Joined
Jul 7, 2004
Messages
157
Type this @ the end of the Macro, although it depends on whether your using a checkbox on a form or on the sheet

Sheet1.CheckBox1.Value = 1
 

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896

ADVERTISEMENT

In the properties for the tick box, specify a linked cell. Then as the last line of your macro, set the value of that cell to be true.



HTH


:cool:
 

gedi

Board Regular
Joined
Jul 7, 2004
Messages
157
If it's a checkbox on a form use something like

Form1.checkbox1.value = 1
 

Booney

New Member
Joined
Aug 2, 2004
Messages
32
Great thanks for your replies. I now have my tick boxes automated!!!

:p
 

Watch MrExcel Video

Forum statistics

Threads
1,122,228
Messages
5,594,934
Members
413,953
Latest member
Arthur1471

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top