View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default Problem with ActiveSheet code

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