ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Multiple Option Controls w/in Worksheet (https://www.excelbanter.com/excel-worksheet-functions/102171-multiple-option-controls-w-worksheet.html)

uberbetty

Multiple Option Controls w/in Worksheet
 

Help...:confused:

I'm trying to put multiple sets of option control buttons in one
worksheet - how do I tell Excel which ones to group together so they
don't effect other groupings?? I have attached an image to help
explain what I'm asking...I need to be able to select one option from
the first list and one from the second, but they are all looking at
each other and you can only select one of the seven instead of one from
each group....how do I fix that??

Thanks!!
Uber Betty (newbie) ;)


+-------------------------------------------------------------------+
|Filename: excel 1.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=5131 |
+-------------------------------------------------------------------+

--
uberbetty
------------------------------------------------------------------------
uberbetty's Profile: http://www.excelforum.com/member.php...o&userid=36935
View this thread: http://www.excelforum.com/showthread...hreadid=566467


Ron Coderre

Multiple Option Controls w/in Worksheet
 

The esteemed Dave Peterson created some neat code that builds the form
for you. See his technique at the below Contextures website:

http://www.contextures.com/xlform01.html

Does that help?

Regards,

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=566467



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com