List Box in Mac

[smund]

In Excel for Windows I put the list in "RowSource", but now I have a Mac and this item doesn't exist.
Can you help me?

 

[mikerickson]

Mac does not support the .RowSource property. Varitations of this are the way that I load a list box.

Dim oneCell as Range

For Each oneCell in Range("A1:A10")
    ListBox1.AddItem oneCell.Value
Next oneCell

 

[smund]

Excuse me, but where I put the code?
In the macro that shows the Userform, or in the Sub UserForm_Click?

Thanks

 

[mikerickson]

I'd put it in either the Userform_Initialize event or the Userform_Activate event.

 

[smund]

Very good.Perfect.Thanks