Is it possible to bold c ertain items in a listbox?

[piyo27]

I have a userform with a text field. Is it possible to bold certain items in a listbox based on the value entered in the text field?

For example, I have a worksheet that contains the max capacity of each room. A list of rooms available for booking will be listed in the listbox. In the userform, there is a text field whereby user enters the no. of participants in a class. Based on the value of the text field, those rooms with capacity equal to or greater than the value in the text field will be bold in the listbox.

 

[RoryA]

No it isn’t, I’m afraid (at least not without a lot of API code to effectively draw on the relevant parts of the screen).

 

[piyo27]

Thanks for the reply

No it isn’t, I’m afraid (at least not without a lot of API code to effectively draw on the relevant parts of the screen).