Creating Listbox

  • Thread starter Thread starter P Dudesek
  • Start date Start date
P

P Dudesek

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 said:
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
 
Back
Top