Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel option button value total

Status
Not open for further replies.

Maine

Technical User
Feb 4, 2001
41
US
I am designing a spreadsheet in Excel 97 that is going to be a survey. Answers to the questions are numbers and I want the user to select a number with a click of an option button. Then I want the answers to the questions totalled. I assume I'd add the button then assign a value (not sure how) then somehow total the values. Any help would be appreciated.
 
Would data validation work for you instead of option buttons?
 
Data validation works fine. I'll be using it alot now that I know about it. Thanks very much for the help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top