Error Handling to Stop Run-time Errors

**Nulladave** · 07-18-2014, 07:01 AM

I have a Userform that asks the user to enter a UK post code into 2 text fields. e.g

txtField1 = L27
txtField2 = 4HD

I then have a Lookup function using txtField1 to search for the first part of the postcode in a list to return a result. Everything works swimmingly until an incorrect post code is entered.

I then get a run-time error which is not ideal for the user.

Is there a way I could write some error handling code that tells the user an invalid post code has been entered rather than getting the run-time error?

My Lookup function is here:

Please Login or Register  to view this content.

This is the current error handling I have in place but this obviously doesn't pick up if an invalid post code has been entered.

Please Login or Register  to view this content.

If there is any standard error handling code to effectively by-pass the run-time error then this should work fine.

Thanks in advance.

**nathansav** · 07-18-2014, 07:12 AM

You could do a countif on the postcode make sure its in the table? You can trap what you have by if len(txtPost1.value)=0 then, NullString is vbNullString also.

Or you can use error trapping, i'd recommend reading up on this.

**romperstomper** · 07-18-2014, 07:22 AM

I'd suggest Application.Match instead:

Please Login or Register  to view this content.

**Nulladave** · 07-18-2014, 08:35 AM

Hi Romperstomper

That code has worked perfectly!

Many thanks for your help

nathansav,

Thanks for your suggestion. Error trapping will come in useful as I get deeper and deeper into the world of VBA so I will be doing some reading up on this as you suggested.

Many thanks

**nathansav** · 07-18-2014, 08:42 AM

Do, as you can use errors to your advantage, so for things like a function to see if a worksheet exists, rather than loop the sheets, you can just error trap setting the sheet to an object, where the error trap returns false, and the error free code will return true.