MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VB Emergency!!!!!!!!!!!


Posted by Ian on July 27, 2001 11:21 AM

HELP!

What should I write that will check all the option buttons on a form, make sure 1 has been selected.

thanks thanks thanks

Ian


Posted by Ivan F Moala on July 28, 2001 4:53 AM


Dim OpB As MSForms.OptionButton

For Each OpB In Me.Controls
If OpB.Value = False Then
'Not selected
MsgBox OpB.Caption & " not selected!"
End If
Next

Ivan

Posted by Ian on July 28, 2001 5:00 AM