Checkbox Macro

[Guest]

Is there a way to have a macro check a checkbox?

Thanks

Adam Bush

 

[Guest]

hi
yes.
if sheet.....
checkbox1.value = true
if form...
me.checkbox1.value = true
but doesn't that defeat the purpose of a check box?

Regards
FSt1

 

[www.exciter.gr: Custom Excel Applications!]

Create a checkbox and link it to a cell (right click on checkbox,
format, control, link cell). Then set your macro to change the value
of the linked cell to True.

www.exciter.gr
Custom Excel Applications!

 

[Guest]

Thank you very much. It was so simple! I didn't know that you could change
the linked cell and it would change the checkbox, i thought it was only vice
versa.

Thanks

Adam Bush