Problem with ActiveSheet code

  • Thread starter Thread starter ordnance1
  • Start date Start date
O

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
 
You need a dot between ActiveSheet and Range...

If ActiveSheet.Range("E2").Value > 0 Then...
 
Thanks to both of you for the speedy response.

Rick Rothstein said:
You need a dot between ActiveSheet and Range...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox will not show list 4
slow macto 2
Option group controlling objects 1
filter that yeilds no results 6
Data Validation - Combo Box open with single click 0
Changing tab color locks the worksheet 3
lists not populating userform 1
shorten sheet name 4

Back
Top