Drop down menu

[Ardus Petus]

Create an Userform with a Listbox in it

HTH

 

[ktyme]

Helllo,
I am trying to create a dropdown menu with individual pricing for each choice.


fence:
4' stockade is $28
5' stockade is $31
6' stockade is $35

I would like each item to be in the dropdown menu and be priced accordingly.

 

[ktyme]

what is a user form?

Create an Userform with a Listbox in it

HTH
--
AP

Helllo,
I am trying to create a dropdown menu with individual pricing for each

[quoted text clipped - 7 lines]

I would like each item to be in the dropdown menu and be priced
accordingly.

 

[Dave Peterson]

You could use a separate (hidden??) worksheet.

Put the descriptions in column A and the pricing in column B.

Column A ColB
4' stockade fence 28
5' stockade fence 31
6' stockade fence 35

Then give that stuff in column A a nice name.

Now you can use that name as the source for the list in a cell that has
Data|Validation applied (say A1).

Then in B1, you can use this formula:
=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

Debra Dalgleish has lots of notes about Data|Validation:
http://www.contextures.com/xlDataVal01.html