Replacing run time error message with a different message

**penny** · 12-08-2009, 04:37 PM

Hello -

I've attached an example of the spreadsheet I'm working on. If you click the "Request Part" button, you will get a pop up box asking you to select a category. From the drop down, select Accessories. You will get a new pop up asking you to enter a part number, the quantity, and who it was requested by. The list is pulled from a worksheet labeled "AccessoryLookupList". If the part added is on that list, I don't have any problems at all with my spreadsheet. However, if a person tries to add a part that is not on the list, I get a runtime error. I know why the error happens, but instead of getting an Excel error pop up, I'd like to have a "Part not found" message box pop up. I'm not sure how to implement this.

Thank you for the help!

**mojo249** · 12-08-2009, 05:14 PM

Hi Penny

Put the following code in Private Sub cmdAccAdd_Click():

Please Login or Register  to view this content.

Dion

**Marzuk** · 12-08-2009, 05:17 PM

Just some pseudocode to get you started here:

Please Login or Register  to view this content.

Run the code, create the error, then sub in that error number for "error" and handle that error with your custom msgbox.

**penny** · 12-08-2009, 05:26 PM

Originally Posted by mojo249

Hi Penny

Put the following code in Private Sub cmdAccAdd_Click():

Please Login or Register  to view this content.

Dion

Perfect, thank you for the quick response!

**penny** · 12-11-2009, 01:37 PM

I ran into an issue; I'm not sure if it's my issue or something with the code from mojo249.

I have some part numbers that start with "11". Whenever I try to select a part number that starts with "11", it tells me the part number is not valid, even though they do indeed match.

I have no idea why this is happening.

**Marzuk** · 12-11-2009, 02:26 PM

Just a guess, the code provided uses a named range so if the part was added OUTSIDE of the named range then it would not be "valid". If the named range used for validation is for example A1:A100, and the new element is in A101 then you need to simply expand the named range.

**penny** · 12-11-2009, 03:21 PM

The range is a dynamic range, so that shouldn't be causing the issue. The code works fine when I'm using a part number that is a mix of numbers and letters. If it's all numbers and starts with "11" I'm running into an issue. Does it have something to do with how the

Please Login or Register  to view this content.

and the

Please Login or Register  to view this content.

are formatted?

**mojo249** · 12-12-2009, 07:12 PM

Hi Penny

What's the error message you're receiving?

Dion

**penny** · 12-14-2009, 10:51 AM

Originally Posted by mojo249

Hi Penny

What's the error message you're receiving?

Dion

Hello Dion -

When it happens, I get my message box note.

Please Login or Register  to view this content.

Replacing run time error message with a different message

LinkBack

Thread Tools

Rate This Thread

Display

Replacing run time error message with a different message

Re: Replacing run time error message with a different message

Re: Replacing run time error message with a different message

Re: Replacing run time error message with a different message

Re: Replacing run time error message with a different message

Re: Replacing run time error message with a different message

Re: Replacing run time error message with a different message

Re: Replacing run time error message with a different message

Re: Replacing run time error message with a different message

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions