joelsoh
11-14-2008, 07:51 PM
Hi all,
I'm trying to learn VBA at the moment, but I'm not finding it easy at all.
I have a userform, with two listboxes.
The aim is to...
1. Call and display information from one column of a spreadsheet, until an empty space is found, (then stop). This I believe needs some sort of loop. I'm unsure.
2. Have those cells values placed into a listbox.
3. Now they're there, use 4 buttons, "Add one, Remove one, Add all, Remove all", to transfer the values from one listbox to the other.
Any clue?
Thanks!
I'm trying to learn VBA at the moment, but I'm not finding it easy at all.
I have a userform, with two listboxes.
The aim is to...
1. Call and display information from one column of a spreadsheet, until an empty space is found, (then stop). This I believe needs some sort of loop. I'm unsure.
2. Have those cells values placed into a listbox.
3. Now they're there, use 4 buttons, "Add one, Remove one, Add all, Remove all", to transfer the values from one listbox to the other.
Any clue?
Thanks!