You need a dot between ActiveSheet and Range...

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

--
Rick (MVP - Excel)


"ordnance1" wrote in message
...
What can I do to get this code to work?


Private Sub UserForm_Initialize()

IF ActiveSheet range("E2").Value0 then OptionButton2.Visible = False

End Sub