Tag Archives: Error

VBA/Excel Error 2023: 7 Fixes to Try

Excel or VBA Error 2023 in Excel is a runtime error that occurs both with and without displaying consistent symptoms. While there is no easy answer for this, I’ll try to explain in detail why you might be seeing it. The description for this error

How to Fix Compile Error: Expected: End of Statement

Introduction Every programming language has its own grammar and vocabulary — technically known as syntax. Having a mastery of any language implies that you have a sound knowledge of its syntax. As a beginner in VBA, you might be confronted with frustrating errors like the

On Error…Go To: Error Handling in VBA

Even when your code is perfectly constructed, the user might not always do what you would expect.  For this reason, you need to insert error handlers into your code whenever there might be a reason that an error might occur. Handling an error when incorrect

VBA Error 400: What Are the Causes and How to Fix It?

Introduction It is often said that debugging is part of programming, and through error messages, the programmer can easily identify where there are problems in his/her code. But as you can see from the above screenshot the VBA Error 400 is one of those annoying

No Thumbnail

Query Dates Type Mismatch Error, Access

Previously in the article Query Dates, Access I’ve explained how you can run queries on date values.  However if double quotes are used in the  criterion section a type mismatch error will occur. In the figure below you can see a query in design mode: This is the