multi-column listbox on userform, multiple issues

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" <nospam@nospam.com> wrote in message
news:e%23ytEHlMGHA.3984@TK2MSFTNGP14.phx.gbl...
> 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" <twogilvy@msn.com> wrote in message
news:eDR5A0lMGHA.1192@TK2MSFTNGP11.phx.gbl...
> 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" <nospam@nospam.com> wrote in message
> news:e%23ytEHlMGHA.3984@TK2MSFTNGP14.phx.gbl...
> > 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.
> >
> >
>
>