Thread: Forms Controls
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuck Taylor Chuck Taylor is offline
external usenet poster
 
Posts: 8
Default Forms Controls

I want to use option buttons for two different choices. After the user
selects "Choice 1" from a list of 6 options, they then select "Choice
2" from 2 options.

Bottom line is that I was planning to read the choices via a linked
cell - say address "E1" for Choice 1 and "F1" for Choice 2. However, I
can't seem to consistently unlink the two groups; i.e., if I chose
"Option 1" from "Choice 2", then the link shows "7". If I change the
linked cell address for the form buttons, they all change to the same
address (same problem for ActiveX). I tried grouping (using a group
box) and that seemed to work for a while but then I moved the controls
and the problem returned. Deleting and re-grouping with a new box
didn't solve the problem.

If anyone can help, I'd appreciate it.

Thanks.