Excel user defined function error
Posted on 2013-01-29
I need to determine if a certain cell is "BOLD".... I've inserted the below code in an attempt; however, when I execute the call I get a compile error: "User-defined type not defined"
Here is code... was placed in a module
Public Function isBold(xlCell As cell) As Integer
Dim isBold As Integer
Dim bolTest As Integer
bolTest = 0
If xlCell.Font.Bold Then bolTest = 1
isBold = bolTest
I also placed the code on the worksheet tab itself... When placed there, I get nothing!
Thanks in advance for your assistance.