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
|