LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Option Buttons

I am a first time option buttons user and have a question. I have created a
spreadsheet which has 4 option buttons for 3 different parties. they a

Approved
Declined
Additional Info Requested
4th button has no text

i set up the 4th button so that when they get the worksheet - i can tell
that no option had been chose as of yet. is this the correct way to do this?

additionally, i have those 4 buttons for three different attys. so atty 1
will have his own buttons (I put initials after the text); atty 2 will have
his own, etc. When there is more than one request that needs approval or
other action - i create another section in the worksheet for the 2nd request.
What I have to do each time however is change the Group Name for each new
set of buttons so that they act independently.

Is there any easier way to do this? If I have 15 requests on one worksheet
it takes me some time to go into each set of buttons and change the
properties. Thanks.
 
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/Radio Buttons John Calder New Users to Excel 7 May 16th 08 03:51 AM
Option buttons: How to get the selected option from a group? naddad Excel Programming 5 December 21st 05 05:09 PM
Using 'Option Buttons' Julian Excel Discussion (Misc queries) 3 August 17th 05 07:36 PM
Navigating between option buttons is not selecting the option drhalter Excel Programming 1 June 3rd 05 02:28 PM
Navigating between option buttons is not selecting the option Gixxer_J_97[_2_] Excel Programming 4 June 2nd 05 02:50 PM


All times are GMT +1. The time now is 09:23 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"