Small Caps 
Author Message
 Small Caps

Does anyone know of a way to format text in Excel with Small Caps like the
MS-Word option?

I have a macro that will make text in selected cells upper case.  Does
anyone know how to reduce the font size in selected cells by 2 points?



Sat, 09 Aug 2003 21:47:46 GMT  
 Small Caps
Sub ReducebyTwo()
Dim nSize As Integer
ActiveCell.Value = UCase(ActiveCell.Value)
nSize = ActiveCell.Font.Size
If nSize > 4 Then
  ActiveCell.Font.Size = nSize - 2
End If
End Sub

or
Select the cell, format=>Cells=>Font and change the size.

Regards,
Tom Ogilvy


Quote:
> Does anyone know of a way to format text in Excel with Small Caps like the
> MS-Word option?

> I have a macro that will make text in selected cells upper case.  Does
> anyone know how to reduce the font size in selected cells by 2 points?



Sat, 09 Aug 2003 23:03:45 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. change small caps to big caps

2. Help: Caps/small caps in Word97

3. Small caps changed to large caps when spell checked

4. using small-caps within query

5. Small Caps

6. Small Caps

7. Small Caps

8. Need help with a Trial Balance for Small Cap Co.

9. Converting a font to small caps

10. Small caps in Office 97


 
Powered by phpBB® Forum Software © phpBB Group