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.