Error Handling in a Macro
I have written a Workbook_Open() script which runs on startup and checks for the presence or absence of a named TextBox, The code that follows this check depends upon whether or not the TexBox exists.
The problem is, I get Error 1004 when I try to delete it and its not there, and the IfError statement does not handle this situation. I have not tried the condition of selecting it when its not there, but I assume I would get the same result.
Is there any other way to determing the presence or absence of a TextBox using a macro?
I have written a Workbook_Open() script which runs on startup and checks for the presence or absence of a named TextBox, The code that follows this check depends upon whether or not the TexBox exists.The problem is, I get Error 1004 when I try to delete it and its not there, and the IfError statement does not handle this situation. I have not tried the condition of selecting it when its not there, but I assume I would get the same result.Is there any other way to determing the presence or absence of a TextBox using a macro? Read More
