I have a checkbox in my excel file. Depending on whether it is checked or not, I would like Cell A1 to grab value from either A2 or A3.
e.g.
Cell A1 = if(CheckBox1.Value = True,A2, A3)
I do not know how to properly write the syntax for this. Thanks in advance!
Richard
e.g.
Cell A1 = if(CheckBox1.Value = True,A2, A3)
I do not know how to properly write the syntax for this. Thanks in advance!
Richard