| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
list boxes
Hi i wish to display data within a listbox on a userform, i can do it
by entering the row source in the properties but can i write it in the userform activate event, the code i am using at the moment is ListBox1.Text = Range("a1:d50").Text this is not working , so any help greatly received john |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
list boxes
ListBox1.ColumnCount = 4
ListBox1.List = Range("a1:d50").Value -- Regards, Tom Ogilvy wrote in message oups.com... Hi i wish to display data within a listbox on a userform, i can do it by entering the row source in the properties but can i write it in the userform activate event, the code i am using at the moment is ListBox1.Text = Range("a1:d50").Text this is not working , so any help greatly received john |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
list boxes
Hi John
ListBox1.RowSource = "Sheet1!A1:D50" HTH. Best wishes Harald skrev i melding oups.com... Hi i wish to display data within a listbox on a userform, i can do it by entering the row source in the properties but can i write it in the userform activate event, the code i am using at the moment is ListBox1.Text = Range("a1:d50").Text this is not working , so any help greatly received john |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
| Questions on combo boxes and list boxes. | New Users to Excel | |||
| list boxes | Excel Programming | |||
| List Boxes | Excel Programming | |||
| List boxes/combo boxes | Excel Programming | |||
Hybrid Mode
