Populate listbox from WS

[schzuki]

Hi there,

I'm working on a system that enables the user to select 5 options from 5 different set of data (1 from each). The data sets can be found in excel worksheets.
Because the data sets are changing over time, I would like to be able to ad to the data without having to go back to the VBA-editor.


I thought I should start small and start with 1 data set. (ws."test".range (A1:A23)

There is a lot of information available on the web, so I came up with some code based on my findings.

Please Login or Register  to view this content.

However, when I run this, the listbox remains empty. What am I missing/doing wrong? Any help is welcome!

[schzuki]

To add to that: I would like to use a userform, so I can group the different listboxes together (for now defined as "UserForm1")

[JapanDave]

Try this,

Please Login or Register  to view this content.

[schzuki]

Like a charm! Thanks JanpanDave!

[schzuki]

More problems with the same project.

So I managed to define the different lisboxes in the same user form. Users can select 1 option in each listbox and then hit 'Save'.
I then want the selected values to be copied to several desinated cells. I coppied the code below from a multiselect-listbox I used in a different project.
It doesn't really work though. I gues the code isn't appropriate for a singleselect-listbox.
Does anyone have any suggestions?

Thanks!

Please Login or Register  to view this content.

NB: the value from lbtarget1 has to go to ws.("Data input").range.("H2")