View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default change label font

Jordan,
Not sure that is actually the solution to your situation, but..

Worksheets(1).Label1.FontSize = 8

NickHK

"Jordan" wrote in message
...
I have a Label on sheet 1 on my workbook that will have both Japanese and
English typed into them. When Japanese characters are added the font size
jumps up about 4 times. So I need to have a way to change the font of all

or
at least a portion of that label back to font size 8 where it starts off.
Thanks in advance,
jordan