Generate the number of an optionbutton in a cell

Ype

New Member
Joined
Apr 23, 2009
Messages
6
I want to create a multiple choise test in MS Excel 2007.


A question is stated on top of the groupbox. 3 Optionbuttons are in that box and hold the answers in the caption.
To create a list so i can compare questions and answers i create two collums; one containing the correct number of the optionbutton with the correct answer in the caption, the other containing the answer given by the user.

Thus I want put 1,2,3 in a cel according to wich optionbutton is selected. But i want to repeat this several times (so i can create different multiple choice questions).

This might be very easy for most of you, but I can't seem to get it working.
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Ype

New Member
Joined
Apr 23, 2009
Messages
6
I hope the question is easy to understand.
If not, let me know.

Thanks in advance.
 

Ype

New Member
Joined
Apr 23, 2009
Messages
6
Going to bed, hoping in the morning an answer will be found.
Thanks in advance (again).
 

Watch MrExcel Video

Forum statistics

Threads
1,102,287
Messages
5,485,906
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top