Hi All,

I have just started using VBA so this might be an easy question but
have been unable to find an answer so far in my searches.

I have created a text box and added text to it, even changed th
background colour all using VBA code. However I am unable to chang
the font bold, text size, and alignment using VBA code for the tex
box.

Can anyone help?

Also another question off the main topic, does anyone know how to tur
the "snap to grid" option on and off using VBA code in excel?

I am using Excel 97, its on a work computer and they have not upgrade
yet.

Any information would be greatly appreciated.

Thank you and hace a nice day.
Shane

--
Shane
-----------------------------------------------------------------------
Shane B's Profile: http://www.excelforum.com/member.php...fo&userid=1646
View this thread: http://www.excelforum.com/showthread.php?threadid=27820