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
Bookmarks