Okay , another question... you know how you can (once you
have highligted in the list of the list box?? you can
just type the frst letter of your choice and it goes to
it?? how do i modify code to where you can repeat that
letter key tillyou get thru a list of "t" 's tillyour
choice comes up?




-----Original Message-----
In the userform it is called RowSource. The actual
property is provided by
the container - (oleObject on worksheet, 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" wrote in
message
...
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!




.