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
|