+ Reply to Thread
Results 1 to 4 of 4

Error handling help please

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    Gainsborough, England
    MS-Off Ver
    Office 2016 & Office 365
    Posts
    87

    Error handling help please

    Hi
    Hoping an easy one for the experts here, some help with error handling please, Userform Textbox (Me.platenumber) refers to sheet names and data is inputted into cells on that sheet, my problem is when a typing mistake happens in the platenumber textbox and they try and add the data it errors out due to there not being a sheet named ***** below is part of the code I am using, how do I pop up a msg box saying that the sheet does not exist retype platenumber(Sheet Name), any help welcome

    Thanx

    J



    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Error handling help please

    Hi
    Have a look at this link:
    http://support.microsoft.com/kb/141571
    Good luck
    Tony

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Error handling help please

    simple method
    Please Login or Register  to view this content.
    for instance
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Registered User
    Join Date
    10-05-2012
    Location
    Gainsborough, England
    MS-Off Ver
    Office 2016 & Office 365
    Posts
    87

    Re: Error handling help please

    Thanks guys

    JosephP, simple when you know how,works great

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Error Handling: Can it report line # where error occurred?
    By PingPing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2010, 03:47 AM
  2. Error handling for error that occurs frequently
    By adyan76 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2010, 02:50 PM
  3. [SOLVED] On Error Goto (Global Error Handling)
    By mpeplow in forum Excel General
    Replies: 3
    Last Post: 04-10-2007, 11:33 PM
  4. Error Handling - On Error GoTo doesn't trap error successfully
    By David in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-16-2006, 02:10 PM
  5. [SOLVED] Error handling with a handling routine
    By ben in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1