Set the Rowsource property of the listbox on the userform to the
following.....
(Change the sheet to the one with the list data)
Sheet1!D43:D33
Alternatively programmatically fill the list box by use the .additem method
and reading the data range. This method is more elegant and allows the
range to expand and contract as controlled by the range definition in your
programme.
Cheers
N.
"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 =---