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

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