On Saturday, March 2, 2013 3:24:10 PM UTC-8, JCO wrote:
Can VB programing within Excel, take the user's Input.



Can a macro run and get the Font Name and Font Size? If so, how is this

done?

Thanks
Hi JCO,

Try this.

Option Explicit

Sub FontIt()
Dim i As Variant, j As Variant
i = Range("A1").Font.Size
j = Range("A1").Font.Name
MsgBox i & " " & j
End Sub

Regards,
Howard