Hi,
I am fairly new to VBA and I need to quickly construct a simple userform for work. To put it simply, I have a list of items each with corresponding price (2 groups, one group is a subset of the other group of major items), I would like to construct a userform where the user can use a combobox to select from the major items, in which the corresponding price of the selected item would be multiplied by a value which is inputted via a textbox on the userform.
I had a good start where I figured out how to input all the major items into the combobox and it works when I press F5. However, I am stuck now when I want to return the corresponding value for formula operations with a textbox input, as I believe this requires some coding. The items and their prices are already listed in a worksheet in adjacent columns, in a way such that a vlookup function can be used normally to return the price values based on specific conditions. Appreciate it if I can be pointed to the right directions, thank you.
I am fairly new to VBA and I need to quickly construct a simple userform for work. To put it simply, I have a list of items each with corresponding price (2 groups, one group is a subset of the other group of major items), I would like to construct a userform where the user can use a combobox to select from the major items, in which the corresponding price of the selected item would be multiplied by a value which is inputted via a textbox on the userform.
I had a good start where I figured out how to input all the major items into the combobox and it works when I press F5. However, I am stuck now when I want to return the corresponding value for formula operations with a textbox input, as I believe this requires some coding. The items and their prices are already listed in a worksheet in adjacent columns, in a way such that a vlookup function can be used normally to return the price values based on specific conditions. Appreciate it if I can be pointed to the right directions, thank you.
. Basically I want to use the Private Sub ComboBox1_Change() function to generate unique lists depending on what was initially selected, then the available items can be either added (moved to the right) or removed (moved back to the left) and the respectively cost values added or subtracted from the final cost after mutiplication by the area input. I think as there are only 6 different minor cost items ( that would appear in the lists) I think we can just define their values inside the codes? But I mean what they are dosent matter we can figure out the general format and then add them in after? The new codes to generate the unique lists based on combobox selection I have tired what i can at the top, please have a look, i think the most simple and method is to exhaustively use the IF function for 9 times until all major room reno types have been covered from B4 to B14, there should be a simplier method though, especially if we need to write further codes for user inputs on the two lists. Thanks again for your help. 
