Rayne
asked on
Worksheet Event Excel VBA
Hello,
I have a worksheet change event code I need to make. if users enters "=Sum(2+3") in a cell, it works fine. But if uswers enter something like this, in a cell
"=Su(1+2)"
it leads to "#Name?" in cell.
How do i capture this error in VBA code?
Thank you
I have a worksheet change event code I need to make. if users enters "=Sum(2+3") in a cell, it works fine. But if uswers enter something like this, in a cell
"=Su(1+2)"
it leads to "#Name?" in cell.
How do i capture this error in VBA code?
Thank you
ASKER
how to capture that formula error in vba worksheet change code?
thank you
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you all :)
Happy to help.
ASKER
errorOnformula.jpg