Posted to microsoft.public.excel.programming

Graham Whitehead Graham Whitehead is offline

external usenet poster

Posts: 72

populating a listbox from an array

Hi, I know there must be a fairly simple solution to this one but I cant
quite get the syntax right. Basically I have a set of values stored in an
array an I simply want to populate the list box with these. one article on
the microsoft website simply gave:

VBA:
'Assign the array to the listbox
ListBox1.List = LArray However, I get an object required error. Can anyone
help me out? Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Populating listbox	Mick[_2_]	Excel Discussion (Misc queries)	1	May 14th 08 10:48 PM
Populating listbox	Andy Brown	Excel Programming	3	August 16th 04 05:40 PM
Populating a ListBox	ToddG	Excel Programming	1	June 24th 04 03:18 AM
Populating TextBox Value--using ListBox	jpendegraft[_15_]	Excel Programming	1	May 2nd 04 03:53 AM
populating multicolumn listbox with an array instead of...	notsureofthatinfo	Excel Programming	0	November 5th 03 10:18 PM

All times are GMT +1. The time now is 02:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us