| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
change txtbx font
This is Bob's response
If perchance they are drawing object textboxes then you could use Sub BBBB() Dim oObj As Shape For Each oObj In ActiveSheet.Shapes If oObj.Type = msoTextBox Then oObj.Select Selection.Font.Size = 12 End If Next End Su -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro that will change the font of a cell if i change a value | Excel Discussion (Misc queries) | |||
| change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
| Change all text one font size up with various font sizes used. | New Users to Excel | |||
| Highlight entire document and try to change font - won't change. | Excel Discussion (Misc queries) | |||
| change display font to actual selected font | Excel Discussion (Misc queries) | |||
![mudraker[_200_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
