Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assessing whether any checkboxes are checked within frame
Is it possible to check and see if at least 1 checkbox in a frame is checked.
I am assuming that you have to group the checkboxes and check on of their properties within a For Each loop Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assessing whether any checkboxes are checked within frame
Dim bChecked as Boolean
Dim ctl as Control bChecked = False for each ctl in Userform1.Frame1.Controls if typeof ctl is MSForms.CheckBox then if ctl.Value then bChecked = True exit for end if end if Next if bChecked = False then msgbox "Please check on box" End if -- Regards, Tom Ogilvy "ExcelMonkey" wrote in message ... Is it possible to check and see if at least 1 checkbox in a frame is checked. I am assuming that you have to group the checkboxes and check on of their properties within a For Each loop Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I count checkboxes that have been checked? | Excel Discussion (Misc queries) | |||
Checkbox checked then show more checkboxes | New Users to Excel | |||
Sum Only Checked Checkboxes | Excel Discussion (Misc queries) | |||
My checkboxes will not stay checked. | Excel Discussion (Misc queries) | |||
how to determine which checkboxes are checked | Excel Programming |