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 f...
Macros and VBA
  • JMB17's avatar
    JMB17
    Feb 18, 2022

    Bob_Hayes Try:

     

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

     

     

JMB17's avatar
JMB17
Bronze Contributor
Feb 18, 2022

Bob_Hayes Try:

 

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

 

 

Bob_Hayes's avatar
Bob_Hayes
Copper Contributor
Feb 18, 2022
I like that but I still get a Subscript out of range error?
  • JMB17's avatar
    JMB17
    Bronze Contributor
    Feb 18, 2022
    Is your worksheet is actually named Sheet3?
    • Bob_Hayes's avatar
      Bob_Hayes
      Copper Contributor
      Feb 19, 2022
      Sheet3 is named Start. I changed the name and it worked, thank you.

Resources