Friday, December 10, 2010

Check if cell is bold or Not

Userdefine function to check the cell is bold or not:-

Function checkbold(xa As Range)

checkbold = xa.Font.Bold

End Function

Suppose if you want to check cell "D1" is bold or not

You need to type =checkbold(d1)

It will return TRUE if bold and FALSE if not.
at
Labels:

1 comment:

  1. Excel VBA CodebaseJanuary 12, 2012 at 7:05 PM

    Hi Alex

    Its working fine in Excel 2007. which version you are using. Also are you using to check the cell value or text on shape .

    ReplyDelete

Subscribe to: Post Comments (Atom)

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...

  • Export Range in Json Format
    Macro to Export Range in Json Format Option Explicit Sub export_in_json_format()     Dim fs As Object     Dim jsonfile     Dim rangetoex...
  • Running SQL Queries within Excel Environment
    If you want to run SQL queries within Excel environment without  connecting to any database, you can do it with creating the ADODB   conn...