Problem with Column on a Userform

Hi,

I have got a userform with 2 Combo Boxes inter-connected (so if yu pick fruit in the first Combo Box, the second one will show bananas, apples.... and if yu pick vegetables in the first one, the second Combo Box will show Tomatoes, peas....) and a button "add". I would like in fact to write a macro so that when someone picks tomatoes, for example, and click the button "add", the price of a tomato appears on the Sheet1.
To do that, I would like to have two columns in my second Combo Box, the first one hidden with the prices and a second column with the names "Tomatoes, peas..." so that when someone clicks "add", the macro takes the value of the first column and put it on A1 Sheet1.

I am a really beginner and I m sure this is easy so if you can help me!!

Thanks

Userforms are not good for storing data. Once the UF is unloaded, any data is lost forever. I would put the price list on a worksheet and have the routine get the value from there. The worksheet could be hidden so it doesn't interfere with the display. If Sheet2 has a list of produce in column A and a list of prices in column B.

Please Login or Register  to view this content.

would return the price of what is selected in ComboBox2.

Hi Koda

I'd go with Mike; definitely the best place to keep the data would be a worksheet and then use additem to add them in. That way you could always keep updating the list.

Once you have the list you want in the combo box then make the width of the second column (ie the price) to be 0. It's one of the properties of the combo box. Make sure, also in the properties, that the bound column is 2 and that the column count is 2. So basically you have the second column in the combo box...you just can't see it as it doesn't have a width.

In your macro attached to the ADD button you can return the [selected.value] to your worksheet.

Andy

Thanks a lot Andy!! I am going to do by this way! As you said both, really simpler!! I will probably struggle on some points and I will probably need your help again!

Thanks