How to get entries on a list box on a form
 

Hi,

I have a number of entries that I would like to list on a form on a listbox.
I've forgotten how to do this.

I need to get the following entries "Toronto", "Oakville", "Vancouver"

Could anyone help me out


thanks in advance

Sandra

How to get entries on a list box on a form
 

by form I assume you mean Userform.

Private Sub Userform_Initialize()
with listbox1
.AddItem "Toronto"
.AddItem "Oakville"
.AddItem "Vancouver"
End With
End Sub

--
Regards,
Tom Ogilvy


"Grd" wrote:

Hi,

I have a number of entries that I would like to list on a form on a listbox.
I've forgotten how to do this.

I need to get the following entries "Toronto", "Oakville", "Vancouver"

Could anyone help me out


thanks in advance

Sandra

How to get entries on a list box on a form
 

That works exactly as I wanted
Thanks very much

"Tom Ogilvy" wrote:

by form I assume you mean Userform.

Private Sub Userform_Initialize()
with listbox1
.AddItem "Toronto"
.AddItem "Oakville"
.AddItem "Vancouver"
End With
End Sub

--
Regards,
Tom Ogilvy


"Grd" wrote:

Hi,

I have a number of entries that I would like to list on a form on a listbox.
I've forgotten how to do this.

I need to get the following entries "Toronto", "Oakville", "Vancouver"

Could anyone help me out


thanks in advance

Sandra