Formatting a List Box in Excel

[JMH022]

Is it possible to change the background color in a list box to a different color (other than the standard 'white')?

I would also like to BOLD the items inside the list box if possible.

Can someone tell me if this is an option in Excel?

 

[phantom1975]

Right-click on the ListBox and select properties. You should be able to change everything there.

 

[JMH022]

Thank you for your reply, but I did that...the option to change the color of the list box is not listed in the properties. 3D shading is NOT what I need. I want to change the background (behind the text) from white to a different color from the color palette. Any ideas?

 

[phantom1975]

BackColor is the property you are looking for. It shows up at the top of the properties list. Otherwise, you can change it with code:

ListBox1.BackColor = 255
'Red

 

[JMH022]

Ahhh, okay. I see where the discrepancy is coming into play. You are refering to the list box from the VBToolbox, right? I am using the one from the Forms toolbar and it does not list the same properties options. Much more limited, it appears. I will see if I can change my form to use the toolbox version, unless you know how to change the properties of the other one.

 

[phantom1975]

I usually stay away from the FORMS and just use the CONTROL TOOLBOX. I really don't know what purpose the FORMS controls serve versus the CONTROL TOOLBOX controls. I find that the CONTROL TOOLBOX controls are much easier to work with.

 

[JMH022]

phantom, thank you for all of your input. I was able to change the control to the Toolbox version with no problem. Many moons ago I was shown the Forms controls and never gave the others a second thought. I guess I will from now on...they are much more versatile. Thank you again!