I want to use the value of a checkbox on a sheet to decide which part of macro to run.
if Checkbox = true then
execute this section if box is checked
else
execute this section if box is unchecked
end if
For the checkbox on sheet, would I need to create an ActiveX Control or a Form Control? Further, once the checkbox is created, how do I determine the name of the object to use in my macro? Thanks in advance for any comments..
Bookmarks