| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Form behind cell entries | Excel Discussion (Misc queries) | |||
| how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
| make a list from another list ignoring duplicate entries from orig | Excel Worksheet Functions | |||
| how to get a list of entries onto a form listbox | Excel Programming | |||
| Need to create unique list from list of multiple entries | Excel Programming | |||
Linear Mode
