Re: List box data

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 02/17/04 

Date: Tue, 17 Feb 2004 14:18:57 -0500

In the userform it is called RowSource. The actual property is provided by
the container - (oleObject on work***, control on userform) thus a
difference. So look for the RowSource propert and set it to
Sheet1!A1:B20

for example. 

-- 
Regards,
Tom Oglivy
"mike" <anonymous@discussions.microsoft.com> wrote in message
news:11bc501c3f588$874db500$a001280a@phx.gbl...
> I noticed that when you placed a listbox on wrksht you
> can use a data list for your ListFIllRange. But when you
> want a listbox on a userform...there isnt a
> ListFillRange. Does this mena i will have to do a ADDITEM
> on a initialize procdure b4 it opens? Can i attached
> alist or reference one?? My data list is about 60 rows
> long?? Did i miss another way somewhere?? any help thanks!
>
>
Quantcast