list box on excel 2000 worksheet

[cardiology nurse]

I am trying to design a form for my boss that uses list boxes. He wants to be able to click on an item in the box and have it appear in the correct space on the form. I am very new at excel, so please keep any suggestions very simple. One person said that I would need to use VBA coding. I don't know what that is. So I am looking for easy, simple to understand instructions on designing list boxes and VBA coding with excel.

 

[stevebausch]

Listboxes on a worksheet are (usually) easy to do. Data / Validate is the menu path to get you there.

Study up on Data Validation; the dialog is easy to comprehend without study, but it never hurts to read the Help files.

 

[uneiman]

The first thing you have to do is enable the "Forms" tool bar, and click on the "Combo Box" icon.
Click anywhere on the worksheet where you would like the drop down list to be.
You can later move and resize by right clicking on it.
Right-click over the "Combo Box" and select "Format Control".
Select Input Range (in my case A1:A15).
Select Cell Link (E5) - any blank cell.
Click OK.
You should be able to see a drop-down list now.
In the cell that you would like to display your selection, type:
=INDEX(A1:A15,E5)
Did that solve your problem?

Book5
	A	B	C	D	E
1	ArizonaCardinals
2	AtlantaFalcons
3	BaltimoreRavens
4	BuffaloBills
5	CarolinaPanthers				4
6	ChicagoBears
7	CincinnatiBengals
8	ClevelandBrowns
9	DallasCowboys
10	DenverBroncos
11	DetroitLions			BuffaloBills
12	GreenBayPackers
13	HoustonTexans
14	IndianapolisColts
15	JacksonvilleJaguars
Sheet1

 

[Joe Was]

Do not start a new post with the same questions.


I answered your other post on how to build a dropdown in cell list at:

http://www.mrexcel.com/board/viewtopic.php?topic=19838&forum=2

You do not need code to do this. You could also do it with code, but this takes programming skill that is hard to come by overnight. I am sure we can help you out with some cut and paste codes to get you started.

Try the no code dropdown first, see the link to your other post. You can see all your posts with the "Search" hyperlink at the upper-right of this page. In "Author" put your "Username" to pull all your posts. There you will find the replies to your posts, we get alot of posts each day and your message may get moved off the screen, so search is the best way to check on replies. JSW


_________________<INPUT type="JSW" value=" Excel On... Coder's!" ID=Text1><spanstyle='font-size:36.0pt;color:#FFCC00'>JSW<o></o></span>[/b]</p><spanstyle='font-size:36.0pt;color:#FFCC00'>Try and try again, " The way of the coder!"<o></o></span>[/b]
This message was edited by Joe Was on 2002-08-23 08:47