Hi everyone,
I am trying to add a range value together but i cant seem to figure out how to do it.
The idea is that the user will select from which Item ID to which Item ID he/she wants in the userform ComboBox1 and ComboBox2, then after pressing "OK" the coding should be able display the selected Item ID range and the addition of "Price of 1" , "Price of 2" and "Price of 3" for the selected range individually in sheet 2.
I also cant figure out how to put the Item ID name into the ComboBox1 and ComboBox2 as the quantity of Item ID and pricing will increase over time therefore, i cannot use the .AddItem.
It is possible to do it? Many thanks
Bookmarks