I have a user form with combo boxes and text boxes, Depending on the values chosen I want to call some other values from a worksheet and fill a row in an array for manipulation and then outputting to a worksheet.
For example:
I uploaded some sample data http://www.sendspace.com/file/femch6http://www.sendspace.com/file/etilg6
For example:
- The user selects Apple from the first combo box
- User types 50 in the first text box
- The user selects Banana from the second combo box
- The user types 30 in the second combo box
- code checks the named range for Apple
- first row of array is filled with the values next to the word apple.
- The values are divided by 100(a constant) and then multiplied by 50(the user variable)
- code checks the named range for Banana
- second row of the array is filled with the values next to the word Banana.
- The values are divided by 100(a constant) and then multiplied by 30(the second user variable)
- The values in the 'columns' are added and put in to a worksheet.
I uploaded some sample data http://www.sendspace.com/file/femch6http://www.sendspace.com/file/etilg6
Last edited: