Consulting

Results 1 to 3 of 3

Thread: Format a value

  1. #1
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location

    Format a value

    Is there a way to format my value "a" without using a "with" statement, and if not could someone give me a lead on how to incorporate it into this If Statment. I must be missing something in the help files.
    Steve

    If Not Intersect(Target, exampleCells) Is Nothing Then
            Target.Value = "a"
    '        .Font.Name = "Marlett"
        End If
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Target.Font.Name = "Marlett"

  3. #3
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Thanks Jake, been racking my brain.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •