Forum Discussion
Bob_Hayes
Feb 18, 2022Copper Contributor
What is wrong with this visual basic formula
I am trying to show a different form based on the content of a cell. The cell I am referencing will have either a 1 or 0 in it.
Worksheets("Sheet3").Range("A11").Formula = "=if("a11"=>"1" Then frmselect.show Else frmfunny.Show)"
Bob_Hayes Try:
If Worksheets("Sheet3").Range("A11").Value >= 1 Then frmselect.Show Else frmfunny.Show