Multiple Option Controls w/in Worksheet

[uberbetty]

Help...

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 |
+-------------------------------------------------------------------+

 

[Ron Coderre]

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