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.

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.

Ah... I'm so used to referencing my sheets by their sheetname (name) instead
of the name that users can change, I was using Sheet4!A2:F10 when I should
have been using the 'common' name, e.g. SourceData!A2:F10. Works like a
charm now.
Thanks Tom!

"Tom Ogilvy" wrote in message
...
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.