I can use VBA to create a text box, how do I set the background colour?

Firstly I'm new to VBA, but trying to learn to make Excel more useful in work.

My company is using Excel 2003(!) and I'm trying to create custom buttons which add text boxes to selected cells - I want to create a series of buttons to create different coloured text boxes. Through lots of google searching, and some background reading I've managed to come up with the following code to create a text box the size of selected cells

Please Login or Register  to view this content.

Despite numerous tries, I can't figure out what code, or where to place it to set parameters such as font size, alignment and fill colour for the text box. Any help greatly appreciated.

Hello irf90,

Welcome to the Forum!

Here is a macro to change some the properties of the Text Box. There are more. To see them you need to view them in the Object Browser for the VB Editor.

Please Login or Register  to view this content.

Thanks for your help Leith, problem solved!

I've been trying to incorporate that sort of code into my existing Macro but to no avail, and it's very frustrating - I'm trying to learn this but it didn't seem to be making much sense at the minute!

Hello irf90,

Trying changing

Please Login or Register  to view this content.

To this

Please Login or Register  to view this content.