View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] john.9.williams@bt.com is offline
external usenet poster
 
Posts: 104
Default Creating a pick list


Jason wrote:
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