Checkbox Macro
Is there a way to have a macro check a checkbox?
Thanks Adam Bush |
Checkbox Macro
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 |
Checkbox Macro
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 |
Checkbox Macro
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 |
All times are GMT +1. The time now is 03:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com