Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi;
The user form, frmOptSelect, has a number of frames, each with a number of option controls. The algoritms for all combinations of options are not currently available, so I'm disabling certain options for now. I'm trying to make sure that an option is selected in each frame on the form before I click the btnOpen button. In: Private Sub btnOpen_Click () event procedure and right at the top, I inserted: ........ CheckOptions which is a regular macro: Sub CheckOptions() Dim myOption As Control Dim myFlag As Integer .................................................. .... ' check options in frame grpSeries For Each myOption In UserForms(1).grpSeries.Controls ......If myOption.Value = True Then myFlag = 1 Next myOption If myFlage < 1 Then MsgBox "Select B- or GEL-Series" .................................................. ..... ' repeat for all frames .................................................. ..... I got " Run-time error '9': Subscript out of range", and the above For Each statement is higlighted! Any suggestions ? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ProtectSheet Options are un-checking after macro | Excel Discussion (Misc queries) | |||
SumProduct - checking for multiple options in one column | Excel Discussion (Misc queries) | |||
Are Error-Checking rules (in Excel Options) workbook-specific? | Excel Discussion (Misc queries) | |||
Error Checking Options - 2000-2003 | Excel Discussion (Misc queries) | |||
spell checking options | Excel Worksheet Functions |