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

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

Hi
You missed a dot:

ActiveSheet.range("E2").Value

regards
Paul
On Dec 24, 5:02*pm, "ordnance1" wrote:
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

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