I am new to VBA and have been trying to develop a form in excel to do some calculations. I want to use a combo box with text options that will be assigned to a variable in the form of an interger. I want ALL of my options and variable contained within the code. I do not want to reference lists or values from the spreadsheet for my list...I want to have my form ask for multiple conditions and calculate my answer and return a single decimal number back to the spreadsheet...I have the form i have the list for the combo box defined and it works. However i can't figure out how to pass these values into a variable and them manipulate them..