Multi Column ListBox

I am not grasping how to setup a multi column listbox (2 columns).

Please Login or Register  to view this content.

Ref: For example:

Please Login or Register  to view this content.

The above Case I want the first column to be "u" with a specific font (use wingdings for examples, I will substitute it later) and the second column to be "(Straigtness)" with the Arial font.
Can this be done?
ListBox4 is setup for multi column (not the sample code), I just dont know how to use it.

Any hints, tips or examples are welcome.

You need to specify the columns,much like use Cells(1,1) in a sheet. Columns start at 0.

Not sure if you can use different Fonts for each column, I suspect not

Something like this

Please Login or Register  to view this content.

The formatting of a list item (font name, size, bold, etc.) applies equaly to all items and all columns equaly.

Have you considered a one column ListBox with

Please Login or Register  to view this content.

Originally Posted by royUK

You need to specify the columns,much like use Cells(1,1) in a sheet. Columns start at 0.

Not sure if you can use different Fonts for each column, I suspect not

Took me a spell, but I finally grasped what you meant.
Thanks, sometimes gentle prodding is all I need.

Please Login or Register  to view this content.

I seem to have another problem I did not notice. The listbox doesn't scroll down to the last entry. It is always below the bottom of the listbox, selectable (barely), viewable (hardly know its there).

Originally Posted by mikerickson

The formatting of a list item (font name, size, bold, etc.) applies equaly to all items and all columns equaly.

Have you considered a one column ListBox with

Please Login or Register  to view this content.

Originally I was using a single column listbox, in this particular case with a special font I went with a multi column listbox hoping to use one font (special font) in the first column and another font in the second column.

Thanks for the info.

Originally Posted by Rick_Stanich

I seem to have another problem I did not notice. The listbox doesn't scroll down to the last entry. It is always below the bottom of the listbox, selectable (barely), viewable (hardly know its there).

Is the listbox on a worksheet?

On a userform.

Try changing the IntegralHeight property

I have tried that, it does clear up the height issue but then the lixtbox bleeds over other items on the userform. Normally that isnt an issue but in this case I am trying to keep the foot print of the userform to a minimum, currently it is (userform) 254.25x441.

I guess I can let it grow a bit more.
Thanks for looking at this..

Oddly enough, I set the listbox height to 115 and integral to true, 3 out of 4 selections actually shrink the listbox height but all the options are clearly visible.

Hello Rick,

Just for general information, since the ListBox is on a UserForm it is possible to control the font, color, and size of each line. The downside is that it requires Sub-Classing the UserForm and that requires LOTS of API calls. Been awhile since I did any Sub-Classing but it is posssible.

Right! Whats an API Call? LOL

Im not going to go that far for a simple text mapping macro.

Hello Rick,

I didn't think you would want to go that route. Just wanted you know it is possible. Perhaps not practical, but possible.

Practical is in the eye of the beholder.

Or, is that insanity?

LOL

thanks for the info