Option Button/Group Box Properties

lenahanr

New Member
Joined
Mar 21, 2004
Messages
8
I am trying to make 10 group box with option buttons in them. I want each box to act indepentley from each other with different cell links. I get them set up but can't seem to have each box act by itself. I.E., whenever I change one button cell link it changes them all. I know I have to name each box, but can;t seem to find where to do that.

Thanks

Rob
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
if you put the option boxes in separate frames (group boxes), it should already work

are you using a userform, or a worksheet?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,458
Members
412,595
Latest member
slim313
Top