I am trying to figure out how to use the checkbox command on a spreadsheet. What I am trying to do is assign three checkboxes (as options which only one can be checked at a time) that concerns a particular cell. Than write a macro that will do different things based on which checkbox is selected for that cell. First, how can I get the checkboxes to work as described on a spreadsheet? Second, I am thinking of some possible way (maybe using IF statements) to write the macro, but how do I write the macro to understand the checkboxes (for instance: IF (checkbox 1) THEN…….ELSE IF (checkbox 2) THEN……..ELSE IF (checkbox 3) THEN…..)? How do I write the checkbox 1,2,3 commands in the if statements so that the macro understands it. Does it have something to do with using true or false statements? And I am open to any other suggestions as to how this macro could be written.
Thanks