List box style
 

I'm using a listbox with the fmListStyleOption so I can check the choices I
wish to include in my spreadsheet.

The problem is that the text corresponding to each check box is extended and
there doesn't seem to be the option to word wrap the text.

So
1) did I miss the word wrap option?
2) could I use tool text tips attached to each list item separately (instead
of to the listbox as a whole)
or is there
3) some other choice?

List box style
 

There is no wrap option for a ListBox. Your only option will be to

1. Extend width of control
2. Edit text
3. Reduce font size
4. Revert to Plain style making more space, user needs to click text



--

Regards,
Nigel




"David Gerstman" wrote in message
...
I'm using a listbox with the fmListStyleOption so I can check the choices
I
wish to include in my spreadsheet.

The problem is that the text corresponding to each check box is extended
and
there doesn't seem to be the option to word wrap the text.

So
1) did I miss the word wrap option?
2) could I use tool text tips attached to each list item separately
(instead
of to the listbox as a whole)
or is there
3) some other choice?