Feb 18 2022 08:57 AM
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)"
Feb 18 2022 09:25 AM
Solution@Bob_Hayes Try:
If Worksheets("Sheet3").Range("A11").Value >= 1 Then frmselect.Show Else frmfunny.Show
Feb 18 2022 10:05 AM
Feb 18 2022 10:29 AM
Feb 19 2022 07:38 AM
Feb 18 2022 09:25 AM
Solution@Bob_Hayes Try:
If Worksheets("Sheet3").Range("A11").Value >= 1 Then frmselect.Show Else frmfunny.Show