Here is what I am trying to do.

I have a worksheet named Vendor List

Cells D4 to D33 contain the data

Now I want to create a userform (i know how to do that) with a
list box (know how to do that) but what I can not figure out
is how to get that D4 to D33 data into the listbox for the
user to select. Valadation is no good in this instance because
I want to be able to insert the users selection in different
worksheets.

Thanks

See replies to your other post!.

"P Dudesek" wrote in message
...
Here is what I am trying to do.

I have a worksheet named Vendor List

Cells D4 to D33 contain the data

Now I want to create a userform (i know how to do that) with a
list box (know how to do that) but what I can not figure out
is how to get that D4 to D33 data into the listbox for the
user to select. Valadation is no good in this instance because
I want to be able to insert the users selection in different
worksheets.

Thanks




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---