Excel Form Macro

5 pts.
Tags:
Microsoft Excel
Microsoft Excel formulas
microsoft excel functions
Microsoft Excel macros
SpinButton
VBA
Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work (long way around programming VBA, I'm not a programer..) I'd make this an attachment but apparently is not allowed in your forum. Anyway, this application is for a text based questionare. Each answer receives a number response from 1-5 and the answers are then Summed in a Cell Reference for further processing. I want only one spin control to select amoung the 32 or so questions to be answered. My model that I wrote (and can no longer understand...) uses radio buttons by each question. The question could be answered when the buton was selected. Once a question is asked the applicant answers they can not go back to change the answer. This must have been coded a zillion times before. I just don't know what to search for. Any ideas or pointers to macro forms would be greatly appreciated. Thanks everyone, rj.

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you send me the workbook I can give you some pointers… msg me privately.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following