Avatar of Rayne
Rayne
Flag for United States of America

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
Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
Doug

8/22/2022 - Mon