How can I calculate user input from a combo box into a formula?
 

I've got a combo box on screen using the Visual Basic Toolbox.

I want to count up the results of the checks in the combo boxes and use this
number in a formula which is being used in the Excel sheet.

Any idea how I can do this?

Similarly I've also got a few Yes/No Radio buttons on the sheet, and
dependent on the response by the user, certain cells should be added into the
formula...or not.

How do I do that?

Ideally I would simply set another cell to a certain number based on the
response, and then use that number in my calculations...for example 0 or 1
for Yes and No respectively...

....fast help here is appreciated 'cause I've got to turn the sheet in
tomorrow.

quizboy2005 (at) hotmail (dot) com