Thread: Object Requi
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
trini trini is offline
external usenet poster
 
Posts: 10
Default Object Requi

why am i getting the error "object required" when i try to use this code?



Private Sub CommandButton1_Click()
Dim numberoption As Range

Sheets("Sheet3").Select
SweetenerOptions.Hide

Set numberoption = Application.InputBox("How many senarios would you
like to consider:", "Options")
numberoption.Value = number

If number = 1 Then
PriceChoices.Label1.Enabled = True
End If

If number = 2 Then
PriceChoices.Label1.Enabled = True
PriceChoices.Label2.Enabled = True
End If