Glad you found what you needed at Debra's site.

But I've found it best to just post followups directly to the newsgroups. There
are lots and lots of people who can answer your question--and you won't have to
wait for me to read my email.



John wrote:

Hi Dave

I go in to your web and found out what I want it, anyway thanks alot for
your information.

JOHN

"Dave Peterson" wrote:

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


--

Dave Peterson