Excel VBA function to turn activecell to bold

Question

I have the following function inside my module   Function Colorize myValue      ActiveCell Select     Selection Font Bold   True     Colorize   myValue End Function   The cell that will use this function should be turning bold - however  I get no error messages back and sad but true  its not turning bold  What am I missing   Thanks

User · Accepted Answer

A UDF will only return a value it won t allow you to change the properties of a cell sheet workbook  Move your code to a Worksheet Change event or similar to change properties   Eg  Private Sub worksheet change ByVal target As Range    target Font Bold   True End Sub

User · Answer

I use               chartRange   xlWorkSheet Rows 1               chartRange Font Bold   true    to turn the first-row-cells-font into bold  And it works  and I am using also Excel 2007   You can call in VBA directly              ActiveCell Font Bold   True   With this code I create a timestamp in the active cell  with bold font and yellow background             Private Sub Worksheet SelectionChange ByVal Target As Range                 ActiveCell Value   Now                  ActiveCell Font Bold   True                ActiveCell Interior ColorIndex   6            End Sub

[vba] Excel VBA: function to turn activecell to bold

Examples related to vba

Examples related to excel

Examples related to excel-2007