| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to format text in a Text box using VBA code
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text format - setting text colour with code | Excel Discussion (Misc queries) | |||
| using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
| remove text with format code for phone numbers | Excel Discussion (Misc queries) | |||
| Macro - Fixed text code needs replacing with variable text | Excel Discussion (Misc queries) | |||
| code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming | |||
Threaded Mode
