Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Syntax to change font type?

Status
Not open for further replies.

ahbyun

Technical User
Dec 11, 2004
9
0
0
KR
Hi! This should be an easy one.

What is the syntax to change the font type using VB.
I'm trying to change a font type of a column in excel.

Thanks!
 
Welcome to Tek-Tips. To get the best from these forums please read faq222-2244. It will guide you to post in the best forums amongst other things. This seems to be a VBA question rather than VB5/6 (this forum).

However most Excel VBA questions can be sorted by recording a Macro and dissecting the code produced. To change font use:

Range("H24").Font.Name = "Arial"


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

For tsunami relief donations

'If we're supposed to work in Hex, why have we only got A fingers?'

for steam enthusiasts
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top