LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
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
ActiveX to Forms controls Sian Excel Discussion (Misc queries) 2 January 31st 08 12:22 AM
Excel forms controls [email protected] Excel Discussion (Misc queries) 1 March 18th 07 04:37 AM
Questions about Forms & Controls hmm Excel Discussion (Misc queries) 3 December 20th 06 01:06 PM
Forms controls Catalin Excel Worksheet Functions 2 May 11th 06 03:44 PM
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM


All times are GMT +1. The time now is 08:28 AM.

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"