Here is some code that runs off the form initialize event. Load the form and
the listbox is populated...

Private Sub UserForm_Initialize()
With ListBox1
.AddItem "Paris"
.AddItem "Rome"
.AddItem "Milan"
End With
End Sub

If you wanted something more specific just ask...

HTH

"Grd" wrote:

Hi,

I'd like to get a list of towns on a listbox automatically. for example,
paris, milan, new york.

Any help would be appreciated.

Thanks in advance
GRd