option buttons...

N

nevoir

Hi Guys,

How do i get a selected option button to set the value of anothe
cell?

Many Thanks, ne
 
M

Mark Graesser

Hi Nev
First you must have each seperate groups of button surronded by a Group Bo

1) Right click one of the buttons in the group
2) Select "Format Control" and go to the Control ta
3) Assign a linked cel

Now the linked cell will display a number corresponding to the selected button. You can now use an IF statement or LOOKUP function with the linked cell as a reference

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- nevoir > wrote: ----

Hi Guys

How do i get a selected option button to set the value of anothe
cell

Many Thanks, ne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste options button disappears 0
MS Project Center-Autolink column fields 0
Request Form - Alert Team Member 0
Program buttons to create a word document 0
Crating User Form to Add Names 1
WORD VBA Search and switch to advanced ... 1
Getting the difference between a "negative" number and a positive 2
Anchor issue with inserting a shape for letterhead 1

Top