VBA User Form LISTBOX formatting - is it possible - how do I do it?

Hello

Excel User Form

I have created a UserForm in the VBE environment and very nice it is too.
It has buttons, frames, text boxes, labels and a LISTBOX.

This is not on a normal sheet.

How, or, is it possible to, format a LISTBOX in a User Form?

I don’t see how I can format the list box apart from font type and size and alignment, (left, centre, right) using the .TextAlign property and this is not selective, it’s all columns or none.

There are some other things I can change in the property section but not a lot and not what I want to change.

I can’t (rather don't know how) make some columns centre justified when the remaining columns are left justified.

I would also like to make one column have word wrap.

I would like to colour the lines (rows) according to a specific criteria in one column (the word pass or fail) or if that’s not possible then make the lines alternate in a light blue shading to ease readability.

I can’t even increase the row high.

Is any of this possible in a user form?

Are there any “methods” to do this?

Or is this all too much for userforms?

Maybe I am googling the wrong things!

Thank you

Hattie

The listbox formatting is limited.
Your row height will be determined by your font size.
It is not possible to change individual row colours, wordwrap is possible by juggling the seperators, but it makes the listbox useless as a selection tool.
You can left, centre & right justify columns by formatting, however what are you using the listbox for ?
upload your workbook it is then far easier to give specific advice.

thank you for the reply - limited formatting was what i had expected unfortunatly.

the spreadsheet is on my computer at work unfortunatly.

Basically the list box contains row of data about whether a product has passed of failed in testing.

i just thought i would make the 'passed' rows green and the 'failed' rows red.
Easy to do in conditional formatting, but the interface doesn't look as nice as a userform.

and i thought the pass/fail column would look neater if it was centered.

ah well...

thanks again

Something I did in the distant past, the indicator changes color according to the entry in column C.
A simple alteration to the code to recognise pass/fail would at least give you an indicator.

thank you Torachan

I will look at the code and make the appropriate changes for it to work on my code.

thank you.

Hattie