• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 24
  • Last Modified:

Options Buttons - display selection on another sheet

I have an Excel 2003 spread sheet with 2 sheets.  One sheet is a form that the 2nd sheet builds from.  One the primary sheet (main) I have 2 option buttons.  I would somehow like to display a character or text in a cell on the 2nd sheet (Services) based on which option button is selected.  

Is this possible?  I can't a way to do this.  Thank you.
  • 2
1 Solution
Martin LissOlder than dirtCommented:
Can you supply a sample workbook?
Roy CoxGroup Finance ManagerCommented:
Are you using Forms Controls? These have a Cell Link option

Imsert an Option Button from the Forms menu

Right Click onit and Choose Format Control

Use the cell Link box to browse to the sheet & cell you want to use.

When the option button is clicked a 1 will appear, if not clicked a 2 will show.

You can use this cell value in an IF formula in another cell to display whatever message that you want
thandelAuthor Commented:
Of course I completely over looked that, thanks
Roy CoxGroup Finance ManagerCommented:
Pleased to help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now