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

Thanks

Adam Bush

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

" wrote:

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

Thanks

Adam Bush

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!


On Nov 5, 8:33 pm,
m wrote:
Is there a way to have a macro check a checkbox?

Thanks

Adam Bush

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

"www.exciter.gr: Custom Excel Application" wrote:

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!


On Nov 5, 8:33 pm,
m wrote:
Is there a way to have a macro check a checkbox?

Thanks

Adam Bush