Problem with ActiveSheet code

[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

 

[Rick Rothstein]

You need a dot between ActiveSheet and Range...

If ActiveSheet.Range("E2").Value > 0 Then...

 

[paul.robinson]

Hi
You missed a dot:

ActiveSheet.range("E2").Value

regards
Paul

 

[ordnance1]

Thanks to both of you for the speedy response.

You need a dot between ActiveSheet and Range...

If ActiveSheet.Range("E2").Value > 0 Then...