+ Reply to Thread
Results 1 to 22 of 22

Unable to Get userForm to Recognise code. With Error message regarding VLookup

Hybrid View

  1. #1
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Unable to Get userForm to Recognise code. With Error message regarding VLookup

    Deleted this useless part of the post....
    Another option is that Me.EntClientIDbx has a value that has no match.... that would return that error. (Textboxes are text, if the lookup is a number then you need to convert to a number)
    Last edited by Arkadi; 03-08-2017 at 09:03 AM.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  2. #2
    Registered User
    Join Date
    03-07-2017
    Location
    Stockport, England
    MS-Off Ver
    2007
    Posts
    91

    Re: Unable to Get userForm to Recognise code. With Error message regarding VLookup

    Thanks Arkadi, I did have a Sheet name anomaly, I'll check again.

  3. #3
    Registered User
    Join Date
    03-07-2017
    Location
    Stockport, England
    MS-Off Ver
    2007
    Posts
    91

    Re: Unable to Get userForm to Recognise code. With Error message regarding VLookup

    I Recall I had to change the Sheet Name as it was called Sheet1 but had (Sheet2) in brackets.

+ 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 trying to import userform into Outlook: Unable to load UserForm.FRX
    By jeffclanders in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2016, 12:36 PM
  2. unable to resolve a #NUM! error message
    By Bill369 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-11-2015, 07:12 PM
  3. Excel 2010 - Unable to Insert Column - Error message not helping
    By tplenert in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-25-2014, 05:36 AM
  4. Replies: 3
    Last Post: 11-08-2012, 07:25 PM
  5. error message - unable to save external link values
    By BitsofColour in forum Excel General
    Replies: 0
    Last Post: 10-04-2005, 03:05 PM
  6. Error message: Unable to record
    By Tim in forum Excel General
    Replies: 0
    Last Post: 01-26-2005, 03:25 PM

Tags for this Thread

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