Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Nevermind..... I was just entering the inital code for these option buttons, when it dawned on me that the "If there is no selection" part of the code natural solves my problem. Well, I hope that my little deviation for thinking clearly helps someone in the future. Amber :) -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
option buttons / group box | Excel Discussion (Misc queries) | |||
group option buttons | Excel Discussion (Misc queries) | |||
Option buttons: How to get the selected option from a group? | Excel Programming | |||
Option Buttons in Group Box | Excel Discussion (Misc queries) | |||
Group Box with Option Buttons | Excel Programming |