Sheet4!A2:F10
should work fine and is the recommended way you should define the RowSource.

There is no wraptext or wordwrap option for entries in the list.

--
Regards,
Tom Ogilvy


"KR" wrote in message
...
Using Excel2003 on Windows2000;

I'm trying to incorporate a multi-column listbox on a userform and can't
figure out how to get the behavior I'd like (if it is even possible).

(1) In the VBE, I got my rowsource and column headers (6 columns, source
is
sheet4, cells A2:F10) so that I could see my data in the VBE (on the
listbox
on my userform). When I actually showed my userform in run mode, the
listbox
was blank and when I re-entered the VBE, my listbox was back to being
blank.
I'm using columnheads=true, boundcolumn=1, columncount=6, rowsource =
A2:F10
[note: I tried Sheet4!A2:F10 but it didn't like the sheet reference, then
actually showed my data when I just left the cell reference- not sure why,
but I suspect that is part of my problem].

Is there a simple way in the listbox properties to assign a fixed range of
cells to populate it? If not, what is the easiest way (least code) to
populate my listbox from my range?

(2) During the short period of time that I had my range showing in the
VBE,
I noticed that those ranges contains more data in some source cells than
the
listbox will show, and I can't find a wordwrap option for the listbox.
Best
case scenario, I'd like to have it determine total row height based on
wordwrap in the 4th column, which has the longer text. The other columns
have less critical information, so I really don't need to see the extra
info
in those other columns- just whatever would show in the same space as
would
be needed by column 4.

Is there a wordwrap property hidden somewhere for multi-column listboxes,
or
am I out of luck?

Thanks in advance,
Keith

--
The enclosed questions or comments are entirely mine and don't represent
the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.