Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Test for Bold Format in VB (97 SR-2)

    Can I test to see if a cell is bold?

    I've tried celltype and cell(format,range) but neither will tell if it's bold. I want to test for it in VB.

    Thanks for your help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Test for Bold Format in VB (97 SR-2)

    Range("A1").Font.Bold will return True if the cell is formatted to be bold, False if the cell is formatted not to be bold, and Null if the text in the cell is partly bold, partly non-bold

Posting Permissions

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