LinkBack URL
About LinkBacks
How can particular listbox rows be greyed out?
My multicolumn listbox really needs to be able to display unmodifyable rows in a different colour, probably grey, does anyone have any idea how to accomplish this with VBA?
Thanks for reading!
- Gordon
How can particular listbox rows be greyed out?
My multicolumn listbox really needs to be able to display unmodifyable rows in a different colour, probably grey, does anyone have any idea how to accomplish this with VBA?
Thanks for reading!
- Gordon
Last edited by Gordon@work; 05-20-2008 at 11:09 PM.
Good morning Gordon@work
The listbox is an object and has a certain number of properties which apply to the listbox as a whole. There isn't an option to colour code or disable particular items in a listbox.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Hello Gordon,
DominicB is correct that there isn't an option to change the line item color. In Visual Basic it is possible because the window handle to the ListBox is accessible through VB code. By having the window handle, you can use the Windows API to change the color of a line item, along with font size, color, etc.
It maybe possible to do this in VBA. I have some code that creates Tool Tips for line items in a ComboBox when you hover over the line. Something I didn't think was possible in VBA. Perhaps I can modify this API code to change the ListBox line item color. It's worth a try.
Sincerely,
Leith Ross
Leith Ross you rescue me regularly with code. I have some to find the userform's window handle, but yours sounds almost ideal already, so yes please.
Thanks very much for your thoughts.
Sincerely,
- Gordon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks