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)
-
If you have added the shape in the sheet and now you want to change it color , text , font size ,etc using VBA. Snapshot below Code- Su... -
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 .