P
ph8
Just a quick question that I couldn't find an answer to after searching
because of how often the words "true" and "false" appear in different
threads.
How, with VBA, can I reverse a cells value from True to False and the
other way around?
The cell in question is A11, the value will always be either true or
false. The below didn't work for me.
cells(11,"A")= -(cells(11,"A"))
The reason I ask this is because I have similar check boxes on two
different sheets, and I need their values to match. I couldn't use the
linked cell option because it wouldn't let me link the cell to a cell in
another sheet. Which is why I am using VBA to change the other cell's
value so that the other sheet's check box changes as well. If theres
an easier way to do this, then I am all ears for suggestions .
Thanks for your help.
because of how often the words "true" and "false" appear in different
threads.
How, with VBA, can I reverse a cells value from True to False and the
other way around?
The cell in question is A11, the value will always be either true or
false. The below didn't work for me.
cells(11,"A")= -(cells(11,"A"))
The reason I ask this is because I have similar check boxes on two
different sheets, and I need their values to match. I couldn't use the
linked cell option because it wouldn't let me link the cell to a cell in
another sheet. Which is why I am using VBA to change the other cell's
value so that the other sheet's check box changes as well. If theres
an easier way to do this, then I am all ears for suggestions .
Thanks for your help.