Creating a pick list

[Guest]

I may be getting in way over my head here. Is it possible to creat a list
that appears over an active sheet. The list would contain 150 names from
another sheet. The reason being is that I need the names people add to the
sheet to match exactly as numerous funtions are based on those names. Any
thoughts or a direction to point me in? Thank you in adavance Jay

 

[john.9.williams]

I may be getting in way over my head here. Is it possible to creat a list
that appears over an active sheet. The list would contain 150 names from
another sheet. The reason being is that I need the names people add to the
sheet to match exactly as numerous funtions are based on those names. Any
thoughts or a direction to point me in? Thank you in adavance Jay

Hi Jason,

You could use the listbox feature within excel VBA, the listbox appears
on a userform, you can assign any data from your spreadsheet to appear
in this listbox. If you need any info on how to do this post back

Johny5

 

[Guest]

jOHNY
Any help you could give me here would be very helpful. This would be my
first time trying anything with VBA so I am a little out of my league. Thank
you for the response. Jay

 

[Bob Phillips]

I suggest you look at Data Validation. Take a look at
http://www.contextures.com/xlDataVal01.html, and also
http://www.contextures.com/xlDataVal05.html

--

HTH

RP
(remove nothere from the email address if mailing direct)