change label font
 

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

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