Populate Outlook Userform Listbox From Excel Data Table

[*shudder*]

Hi Guys,

I know how to populate a Userform Listbox from within excel, but I want to create a listbox in Outlook to be populated from data in the first column of an Excel table. At the moment I have this from within Excel:

Me.ListBox1.List = Sheets("Sheet1").ListObjects("Table1").ListColumns(1).DataBodyRange.Value

Not sure if this is the right place to ask, if not please tell me.