One question 3 radio button (choices). Show selected value in cell A1.

Thanks,
JP aaa Radio-Buttonxls.xls
easycapitalAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
See the attached workbook.

You must first assign a cell link to capture which radio button is selected.  I assigned the result to cell B1 and then "hid" that cell by changing the font to white.  
format control
Since the result is numeric (1,2,3...and so on), you then use the CHOOSE function to return a corresponding letter.

Radio-Buttons.xlsx
0
 
StephenJRCommented:
Are you actually using radio buttons?
0
 
NitzanleConnect With a Mentor Commented:
Please see the attachment that should be what you need.

Regards,
Nitzan
Radio-Buttonxls.xls
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

 
easycapitalAuthor Commented:
Hi,

I used parenthesis to simulate it.
Please ignore my file.
I am looking for an example that utilizes three connected radio buttons.

Thanks,
JP
0
 
easycapitalAuthor Commented:
Hi Glenn,
Precisely what I am looking for.
How do I find "Forms" in excel 2003?
Thanks,
JP
0
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
In Excel 2003, right-click in an empty space in the toolbar area on top and then select "Control Toolbox."

You can choose the radio buttons there.  You will have to view the Properties window for each option button and change the "LinkedCell" value to where you want that result to go in the worksheet.
0
 
easycapitalAuthor Commented:
Thanks,
Jp
0
All Courses

From novice to tech pro — start learning today.