Greetings fellow earthlings!
I'm trying to create a form with check boxes that causes a macro to be run when a check box is checked. I've done a bit of research on the matter and have come to the conclusion that the best way to do this is to use a function similar to the below:
Sub "sheet name" ()
If A1 = 1 Then
Run (["insert macro name")
Else
End Sub
This function works, as if A1 doesn't = 1 the macro will not run, but it will run if A1 does = 1. The issue I am having is getting it to run when I want it to run.
To elaborate a bit to my specific case:
If I have a check box in A1 that returns the values "true" if checked and "false" if not checked to A2,
and I want to hide cells A4-A7 when the A2=True, and unhide them when A2=false,
how would I go about this?
Bookmarks