Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
how to create a formula to hide specific rows after meeting requi | New Users to Excel | |||
returning pivottable object from a range object | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming |