Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Testing a group of option buttons for a selection.


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
option buttons / group box texas2001 Excel Discussion (Misc queries) 1 December 17th 09 06:43 PM
group option buttons umba-sr Excel Discussion (Misc queries) 1 March 7th 06 02:03 PM
Option buttons: How to get the selected option from a group? naddad Excel Programming 5 December 21st 05 05:09 PM
Option Buttons in Group Box JAMES T. Excel Discussion (Misc queries) 4 March 22nd 05 08:59 PM
Group Box with Option Buttons Tom Ogilvy Excel Programming 0 April 1st 04 04:15 AM


All times are GMT +1. The time now is 03:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"