Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In article , bg18461
says... Thanks for everyone's responses so far, I do appreciate it, now back to the code. Below shows the code and the error as I have it in my program, any hints... Private Sub OptionButton1_Click() Dim i As Long For i = 23 To 190 Worksheets("Sheet4").OLEObjects("Label" & i).Visible = False Next i ERROR: Run-time error '9': Subscript out of range Weren't you working with Textboxes, not Labels? If there are fewer labels then textboxes then you'll get that error. See ya Ken McLennan Qld Australia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Enter Range | New Users to Excel | |||
How do you enter input range for a histogram | Excel Discussion (Misc queries) | |||
How do you enter input range for a histogram | Excel Discussion (Misc queries) | |||
User must enter something in a range of cells | Excel Discussion (Misc queries) |