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

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

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

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)


"Jason" wrote in message
...
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