Results 1 to 3 of 3

Thread: What is the vba syntax for Font & Interior ColorIndex

  1. #1
    Join Date
    May 2011
    Posts
    69

    What is the vba syntax for Font & Interior ColorIndex

    I am looking for vba syntax for Font & Interior ColorIndex. There are various refrences on web but I am not able to properly figure from where should I start. I had tried some sample code and faced many errors.

  2. #2
    Join Date
    Aug 2010
    Posts
    14

    Re: What is the vba syntax for Font & Interior ColorIndex

    The specific object of this sheet is to identify and explain the basic syntax of VBA. What is already interesting to note is that the VBA (Visual Basic for Application) is a language 'Basic', so simple! The number of basic syntax of the language is limited and their knowledge will likely save you a lot of trouble due to syntax errors.

  3. #3
    Join Date
    Sep 2010
    Posts
    47

    Re: What is the vba syntax for Font & Interior ColorIndex

    Try the following code
    Code:
    Option Explicit
    
    Sub 
        With Cells.Font
            .Name = "Arial Black"
            .Size = 26
            .Strikethrough = False
            .Superscript = False
            .Subscript = False
            .OutlineFont = False
            .Shadow = False
            .Underline = xlUnderlineStyleNone
            .ColorIndex = xlAutomatic
            .Bold = True
        End With
    End Sub

Similar Threads

  1. What 3D software is the best for Interior Design
    By Measurer in forum Windows Software
    Replies: 9
    Last Post: 08-03-2011, 10:49 PM
  2. interior design software needed
    By Richard B Rufus in forum Windows Software
    Replies: 4
    Last Post: 25-04-2010, 10:55 AM
  3. Career in interior designing
    By lisanancy in forum Education Career and Job Discussions
    Replies: 3
    Last Post: 19-11-2009, 01:33 PM
  4. command-line syntax for notepad or wordpad? open w/ font
    By Toshaan in forum Windows XP Support
    Replies: 2
    Last Post: 09-02-2008, 12:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,675,837,432.50601 seconds with 17 queries