View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Viewing a worksheet within a Userform

All the data in the listbox is a string, so you can format you dates and
enter them as strings as you load them

Multilines/text wrapping in a listbox row - I don't believe so.

A grid, no I don't believe that is supported either

You might want to try the Office Web Components - spreadsheet component

or use a 3rd party grid control.

--
Regards,
Tom Ogilvy




"chris_waldie"
wrote in message
news:chris_waldie.22glhn_1138643702.3073@excelforu m-nospam.com...

Ok.

I have made some initial progress and can populate the listbox with all
entries matching a single criteria. Before I proceed though, I did have
a couple more questions that have not revealed themselves to me yet.

Can I control the format within a multi column listbox.

For example some of my fields are dates of a specific format which the
listbox displays in the default mm/dd/yyyy.

Also, can I allow for textwrapping as some of the entries contain too
much text just to have a large column width defined?

And can the lisbox contain a grid to separate items visually?

The listbox is a good start, although visually it will need some
tweaking for me to proceed with it as a solution.

Thanks again.


--
chris_waldie
------------------------------------------------------------------------
chris_waldie's Profile:

http://www.excelforum.com/member.php...o&userid=18853
View this thread: http://www.excelforum.com/showthread...hreadid=506341