Macro to tick checkbox automatically
 

Hi,
I have a spreadsheet with a macro assigned to a button, with a checkbox
(from the control toolbar) next to this button for the user to manually tick
when they have run the macro. Is there a way for the checkbox to be ticked
automatically when the button is clicked?
Thanks!

Macro to tick checkbox automatically
 

Just add code in the macro assigned to the button

Activesheet.CheckBox1.Value = true

--
Regards,
Tom Ogilvy


"PaulJ" wrote in message
...
Hi,
I have a spreadsheet with a macro assigned to a button, with a checkbox
(from the control toolbar) next to this button for the user to manually
tick
when they have run the macro. Is there a way for the checkbox to be
ticked
automatically when the button is clicked?
Thanks!

Macro to tick checkbox automatically
 

Thanks Tom, I've adapted this slightly as my checkboxes aren't necessarily
CheckBox1. I've inserted the following code into my macro and it works
nicely:

With ActiveSheet
.Checkboxes.Value = True
End With

I wondered if anyone knows whether checkboxes can be protected? Ideally I
would like my macro to determine whether the checkbox is ticked or not.

Regards, Paul

"Tom Ogilvy" wrote:

Just add code in the macro assigned to the button

Activesheet.CheckBox1.Value = true

--
Regards,
Tom Ogilvy


"PaulJ" wrote in message
...
Hi,
I have a spreadsheet with a macro assigned to a button, with a checkbox
(from the control toolbar) next to this button for the user to manually
tick
when they have run the macro. Is there a way for the checkbox to be
ticked
automatically when the button is clicked?
Thanks!