Get values from columns with variable amount of rows to a list box in a userform?

[Rob*]

Hi.

I need som VBA help.
I have a ListBox with three columns. These columns should be filled with values from column A to C.
It's fine this far, and I can figure out how to get the values but with massive code to get values from each cell if I know how many rows I have...

Now, as the rows with values in the columns will increase or even decrease I need something that can figure out how many rows of values I have and only add these rows.
Some kind of loop that adds row by row from all three columns?

Anyone have a solution for this?

 

[diddi]

can you use the Shapes object?

 

[Rob*]

They all have names, and if you don't like the names you can change them.

How many listboxes are there?

Also, how did you create them?

That's quite important as the exact code you need depends on whether it's an ActiveX control or a Forms control.

How do I change the name? I've used a Form contol.

 

[Norie]

In the top left, next to the formula bar there's the Name Box.

When you select the control that should show it's name.

If you want to change it's name then you can just enter it in the name box.

 

[Rob*]

In the top left, next to the formula bar there's the Name Box.

When you select the control that should show it's name.

If you want to change it's name then you can just enter it in the name box.

Oh, that's easy.

Now, how do I populate the listbox automatically with the code I got earlier in this thread?

LastRow =  Range("A"&Rows.Count).End(xlUp).Row   
Listbox1.List = Range("A1:C"& LastRow).Value

Can I run it from Worksheet_Activate? Someone did not recommend that. What can I do instead?