Drop down menu
 

Create an Userform with a Listbox in it

HTH
--
AP

"ktyme" <u21691@uwe a écrit dans le message de news: 60007974f9796@uwe...
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.

Drop down menu
 

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.

Drop down menu
 

what is a user form?

Ardus Petus wrote:
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.

Drop down menu
 

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

ktyme wrote:

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.

--

Dave Peterson