Problem with ActiveSheet code

  • Thread starter Thread starter ordnance1
  • Start date Start date
O

ordnance1

What can I do to get this code to work?


Private Sub UserForm_Initialize()

IF ActiveSheet range("E2").Value>0 then OptionButton2.Visible = False

End Sub
 
You need a dot between ActiveSheet and Range...

If ActiveSheet.Range("E2").Value > 0 Then...
 
Thanks to both of you for the speedy response.

Rick Rothstein said:
You need a dot between ActiveSheet and Range...

If ActiveSheet.Range("E2").Value > 0 Then...
Click to expand...
 
Back
Top