View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ordnance1[_2_] ordnance1[_2_] is offline
external usenet poster
 
Posts: 92
Default Problem with ActiveSheet code

Thanks to both of you for the speedy response.

"Rick Rothstein" wrote in message
...
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