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
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
when you record your macro couldnt the final stage be to tick the box, then click stop recording.?
 
Upvote 0
This doesnt work, it doesnt record you ticking the box. I tryed that option already.
Any other ideas anyone?
 
Upvote 0
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
 
Upvote 0
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:
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,908
Members
448,532
Latest member
9Kimo3

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
Back
Top