Forum Discussion

Bob_Hayes's avatar
Bob_Hayes
Copper Contributor
Feb 18, 2022
Solved

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

     

     

4 Replies

  • JMB17's avatar
    JMB17
    Bronze Contributor

    Bob_Hayes Try:

     

    If Worksheets("Sheet3").Range("A11").Value >= 1 Then frmselect.Show Else frmfunny.Show

     

     

    • Bob_Hayes's avatar
      Bob_Hayes
      Copper Contributor
      I like that but I still get a Subscript out of range error?
      • JMB17's avatar
        JMB17
        Bronze Contributor
        Is your worksheet is actually named Sheet3?

Resources