I want to create a pull down menu list so I can choose
the cell value picking from the list. I have create a
list with a code and the the catagory description. I
want the pull down menu to have the format "CODE:
DESCRIPTION" but on place the Code in the cell. Is there
a way to do this in VBA. I know in excel I can easily
create the pulldown method but I don't think it
accommodates my format. Thanks for your help

I've done this by using two cells. The first includes a drop down data
validation that references a list that concantenates a product code and a
product names. The cell with the validation might be cell "A1" and an entry
might look like " P03 - Blue Widgets". The second cell includes the product
code from the first cell. A formula might be something like =
left(A1,find("-",A1)-2). This would result in "P03" being placed into the
second cell.

- John Michl


"BrianB" wrote in message
om...
I suggest you use Data Validation

Regards
BrianB
===============================

"Chris" wrote in message
...
I want to create a pull down menu list so I can choose
the cell value picking from the list. I have create a
list with a code and the the catagory description. I
want the pull down menu to have the format "CODE:
DESCRIPTION" but on place the Code in the cell. Is there
a way to do this in VBA. I know in excel I can easily
create the pulldown method but I don't think it
accommodates my format. Thanks for your help

I agee, the best way is to use data validation, list and
then either reference the data or type your list in
-----Original Message-----
I've done this by using two cells. The first includes a
drop down data
validation that references a list that concantenates a
product code and a
product names. The cell with the validation might be
cell "A1" and an entry
might look like " P03 - Blue Widgets". The second cell
includes the product
code from the first cell. A formula might be something
like =
left(A1,find("-",A1)-2). This would result in "P03"
being placed into the
second cell.

- John Michl


"BrianB" wrote in message
. com...
I suggest you use Data Validation

Regards
BrianB
===============================

"Chris" wrote in message
.. .
I want to create a pull down menu list so I can choose
the cell value picking from the list. I have create a
list with a code and the the catagory description. I
want the pull down menu to have the format "CODE:
DESCRIPTION" but on place the Code in the cell. Is
there
a way to do this in VBA. I know in excel I can easily
create the pulldown method but I don't think it
accommodates my format. Thanks for your help


.