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
|