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