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.
Subscribe to:
Post Comments (Atom)
-
you have saved multiple images in a folder and you want to add those images as comment to cells where image name and cell value are same] He...
-
If you want to add a new pop up button on mouse right click menu and as soon as you click on it . It shows you multiple buttons with macro a...
Hi Alex
ReplyDeleteIts working fine in Excel 2007. which version you are using. Also are you using to check the cell value or text on shape .