"tigermoth" wrote:

How do I create a drop down list for selection.

If I want the following in my drop down list :-

89901 Blue Strips 1"
89902 Blue Strips 2"
90001 Red Strips 1"
90002 Red Strips 2"

Say if I select 89902 Red Strips 2" form the drop down list and only want
89902 to appear in the cell.

Correction - Say if I select 89902 Blue Strips 2" form the drop down list
and only want 89902 to appear in the cell.