I don't think you should use two comboboxes. The second one should never be
used--it'll only be displayed to the user.

In fact, I think it would be much easier to drop the comboboxes and use
Data|Validation for just the cells that will contain the item name.

Then use a formula in column B:
=if(a1="","",vlookup(sheet2!a:b,2,false))

and in d1:
=if(a1="","",b1*c1)

You can find lots of tips for Data|Validation at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

John wrote:

Hi

I need some one help.....

Colum 1: Item Name Colum 2: Price List
A1 B1
A2 B2
A3 B3

so on......

I insert 2 combo boxes. Box 1 (property, input range A1........A20)
cell link
F1

Box 2 (property, input range B1........B20)
cell link
F1
I open box 1 (A1) than box 2 automatically appear (B1) (price)
I will put number in C1 than I would like to get answer [box 2 price (B1) *
C1] in D1.

I hope you will clear my answer, kindly reply my answer ASAP.

Yours kindness would be appreciated.

Many thanks

JOHN

--

Dave Peterson