MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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


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

thanks thanks thanks


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


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