View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amber_D_Laws[_71_] Amber_D_Laws[_71_] is offline
external usenet poster
 
Posts: 1
Default Testing a group of option buttons for a selection.


Hello again!

The following code was provided to me by Tom Ogilvy about a week ago to
test a drop down list combo box to see if a selection, any selection had
been made.
I would like to know how to code for a similar behavior concerning a
grouping of option buttons (six to be precise).

Thanks in advance,
Amber


Code:
--------------------
'Tests to see if a Project Manager has been chosen from the drop down list
If cmbPMList.ListIndex < -1 Then
'a selection has been made, so do nothing
Else
MsgBox "You must select a project manager before continuing." & Chr(13) & _
"Please try again."
Exit Sub
End If
--------------------


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=512903