Excel 2003: Help with Drop Down List
 

I am using Excel 2003 and am trying to set up a drop down box so that my
staff can use a pre-defined list of codes to populate a field in the
spreadsheet. So that the field width can stay managable each code will
consist of 2 or 3 characters (just like state abbreviations). To avoid
confusion and help staff remember what each code means, I would like the
explanation of each code to also appear in the drop down box or at least have
the explanation appear in the drop down box but have only the code appear in
the spreadsheet. For the life of me I just can't figure out how to do this.
Anyone have any suggestions.

agilek9

Excel 2003: Help with Drop Down List
 

Hi agilek9,

You must use a drop down from the Control Toolbox, not Forms. Go to the
properties of the box. In the properties go to ListFillRange. If your code
explanations are in A1 to A5 and the codes are in B1 to B5, put A5:B5 in the
ListFillRange. Set the BoundColumn to 2. Link the box to wherever you want it
to display.

Cheers.

Squeaky


"agilek9" wrote:

I am using Excel 2003 and am trying to set up a drop down box so that my
staff can use a pre-defined list of codes to populate a field in the
spreadsheet. So that the field width can stay managable each code will
consist of 2 or 3 characters (just like state abbreviations). To avoid
confusion and help staff remember what each code means, I would like the
explanation of each code to also appear in the drop down box or at least have
the explanation appear in the drop down box but have only the code appear in
the spreadsheet. For the life of me I just can't figure out how to do this.
Anyone have any suggestions.

agilek9

Excel 2003: Help with Drop Down List
 

Here is a nice tutorial:
http://www.contextures.com/xlDataVal01.html#Dropdown

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Squeaky" wrote:

Hi agilek9,

You must use a drop down from the Control Toolbox, not Forms. Go to the
properties of the box. In the properties go to ListFillRange. If your code
explanations are in A1 to A5 and the codes are in B1 to B5, put A5:B5 in the
ListFillRange. Set the BoundColumn to 2. Link the box to wherever you want it
to display.

Cheers.

Squeaky


"agilek9" wrote:

I am using Excel 2003 and am trying to set up a drop down box so that my
staff can use a pre-defined list of codes to populate a field in the
spreadsheet. So that the field width can stay managable each code will
consist of 2 or 3 characters (just like state abbreviations). To avoid
confusion and help staff remember what each code means, I would like the
explanation of each code to also appear in the drop down box or at least have
the explanation appear in the drop down box but have only the code appear in
the spreadsheet. For the life of me I just can't figure out how to do this.
Anyone have any suggestions.

agilek9