Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ray
 
Posts: n/a
Default Can I use more than one set of option buttons in a worksheet?

In order to use option control buttons in a single worksheet to control more
than one sort of choice, how do I get new buttons to return a new set of
sequential numbers?
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

I'm not clear what your question is, but you might try enclosing
your option buttons in a Group Box or Frame control.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ray" wrote in message
...
In order to use option control buttons in a single worksheet to
control more
than one sort of choice, how do I get new buttons to return a
new set of
sequential numbers?



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Just to add to Chip's response:

If you used optionbuttons from the Forms toolbar, put a nice groupbox (also from
the forms toolbar) around each group.

If you use optionbuttons from the control toolbox toolbar, go into design mode
(icon on that same toolbar) and rightclick and provide a unique groupname
property for each optionbutton group.

(each optionbutton within the same group should have the same groupname--but
different than the other groups (did that last sentence help????))

The default groupname is the sheet name, so they're all grouped together.


Ray wrote:

In order to use option control buttons in a single worksheet to control more
than one sort of choice, how do I get new buttons to return a new set of
sequential numbers?


--

Dave Peterson
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
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 04:07 PM
Executing macro for all worksheet from a different worksheet Biti New Users to Excel 3 December 8th 04 11:05 AM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 07:49 PM
Linking items GREATER THAN O on another worksheet in the same Work Eddie Shapiro Excel Discussion (Misc queries) 4 December 1st 04 03:55 PM
Worksheet name and Backward compatibility Rich Excel Discussion (Misc queries) 3 November 30th 04 07:10 PM


All times are GMT +1. The time now is 06:25 PM.

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"