User Define Function

[bwchowdhury]

I want to create my own function for making Bold a cell value.
Like this

=BOLD(A1)

Can anybody tell me the exact code in VBA editor under Function BOLD ?
Like this ...

function bold()

bold = ..........????.............

End function

 

[Peter_SSs]

Welcome to the MrExcel board!

You could try this UDF. It will return ..

TRUE if the whole cell is formatted as Bold
FALSE if the whole cell is formatted as not Bold
0 if some characters are formatted as bold and some are not

Note that changing the formatting of a cell (eg from Bold to not Bold) will not automatically cause the function to update its value.

Function IsBold(r As Range) As Variant
  IsBold = r.Font.Bold
End Function

 

[jproffer]

I want to create my own function for making Bold a cell value.

If you meant this literally...that you want to MAKE the cell bold, then a function won't do that. Functions have rules they abide by, one of which is, they can't change the formatting or value of another cell.

Think of it like this, a function can test for value or formatting that is already set and use that information to return almost anything you want (sum/count/average/etc of bold cells...or yellow cells or italic cells or wingdings cells)......a subroutine can set value or formatting automatically.

If you want to MAKE the cell bold, you need a subroutine...maybe attached to a button on the worksheet.