drop-down list box

[cardiology nurse]

I am very new to excel. My boss has asked me to design a form in excel 2000 so he can click on a item in a list box and have it appear in the correct column. Can someone explain in simple terms how to do this?
This message was edited by cardiology nurse on 2002-08-23 05:45

 

[Joe Was]

Use an in-cell dropdown or cell trigger UserForm.

An in-cell dropdown is an active cell list. When the user clicks in the cell a box opens with a list of items for the user to select from. When the user selects an item from the list, it is displayed in the cell.

To do this, from the toolbar, select:

Data-Validation-Settings, Allow: List, then your choice of list data reference;

Source: a,b,c
Source: =AA1:AA20
Source: =myList
[where "myList" is a named range]

Check the box "In-cell dropdown"
and/or "Ignore Blank"

A UserForm will require VBA coding, if you can code you may want to go that way.

Hope this helps. JSW