Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default Radio buttons: "mutually exclusive" property?

I want to use radio buttons on a Userform to allow the user to select
an item from Column A and another item in Column B. As I'm aligning
fields I click the Run Macro button and the Userform appears on
screen. When I click a radio button the previously selected buttons de-
selects. That would be fine, ordinarily, but I need the choice from
column A to persist when the user selects from column B.

Is there a radio button property that enables / disables mutual
exclusivity, or to allow mutual exclusivity between certain radio
buttons only?

Thanks
Dave O



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default Radio buttons: "mutually exclusive" property?

Figured it out, thanks anyway!
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default Radio buttons: "mutually exclusive" property?

The GroupName property will do it. The help file explains it well.

--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"DaveO" wrote in message
...
I want to use radio buttons on a Userform to allow the user to select
an item from Column A and another item in Column B. As I'm aligning
fields I click the Run Macro button and the Userform appears on
screen. When I click a radio button the previously selected buttons de-
selects. That would be fine, ordinarily, but I need the choice from
column A to persist when the user selects from column B.

Is there a radio button property that enables / disables mutual
exclusivity, or to allow mutual exclusivity between certain radio
buttons only?

Thanks
Dave O





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
Make range of cells mutually exclusive Diddy Excel Discussion (Misc queries) 4 July 18th 08 09:42 AM
Is there a way to make 6 columns mutually exclusive? Sandie D Excel Worksheet Functions 1 November 20th 06 10:09 PM
2 IF Statements not mutually exclusive Bev Excel Discussion (Misc queries) 2 August 24th 06 05:23 AM
Making checkboxes mutually exclusive instructorjml Excel Discussion (Misc queries) 3 April 6th 06 06:45 AM
Mutually exclusive values scantor145[_23_] Excel Programming 1 March 31st 06 04:02 PM


All times are GMT +1. The time now is 11:30 PM.

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

About Us

"It's about Microsoft Excel"