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.