+ Reply to Thread
Results 1 to 4 of 4

Userform Match - unable to get the match property of the worksheetfunction class - Help!

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    Shipley, UK
    MS-Off Ver
    Excel 365
    Posts
    76

    Userform Match - unable to get the match property of the worksheetfunction class - Help!

    Hi guys,

    I have a userform, that when initializes checks to see if the current computer name of the user is currently active, but keep getting the error "Unable to get Match property of the worksheetfunction class"

    Any help would be much appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474

    Re: Userform Match - unable to get the match property of the worksheetfunction class - Hel

    Try...

    Please Login or Register  to view this content.
    Note that the row number returned is relative to the defined range.

  3. #3
    Registered User
    Join Date
    08-06-2012
    Location
    Shipley, UK
    MS-Off Ver
    Excel 365
    Posts
    76

    Re: Userform Match - unable to get the match property of the worksheetfunction class - Hel

    brilliant, works a treat, thank you

  4. #4
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474

    Re: Userform Match - unable to get the match property of the worksheetfunction class - Hel

    You're very welcome! Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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