LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,549
Default Maintaining Text Box Font Setting (Excel) using VB



With Worksheets("Sheet17")
.Unprotect "led52not"
.Shapes("Text Box 2").TextFrame.Characters.Text = "P"
.Shapes("Text Box 2").TextFrame.Characters.Font.Name = "Wingdings 2"
End With
--
Can I go back to sleep now? <g
'--
Jim Cone
Portland, Oregon USA
( Excel add-in... http://tinyurl.com/SpecialSort )




"Doug Robbins - Word MVP"
wrote in message ...
That achieves nothing, but if you must do, you should not send it to the
wrong newsgroup as well.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com




"golf4" wrote in message
...
Just thought I'd try to bump my query once. Thanks




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintaining Text Box Font Setting through VB golf4 Excel Programming 4 May 24th 10 05:05 AM
Default font for pasted text in text boxes - Excel 2007 MS OFFICE USER EIT Excel Discussion (Misc queries) 0 March 25th 10 09:01 PM
setting the font type for all comments on excel spreadsheets Delquestion Excel Discussion (Misc queries) 3 October 8th 09 02:21 PM
Excel 2003 - setting the Comment font size default rickz Excel Worksheet Functions 3 July 16th 07 03:53 AM
Maintaining Text Formatting in a Lookup loscherland Excel Discussion (Misc queries) 2 April 21st 06 04:26 PM


All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"