+ Reply to Thread
Results 1 to 2 of 2

Invalid Number of Arguments Error 1004, If statement checks if userform values match colum

  1. #1
    Registered User
    Join Date
    10-17-2023
    Location
    Kingston, Ontario
    MS-Off Ver
    Excel 365 (2016)
    Posts
    3

    Invalid Number of Arguments Error 1004, If statement checks if userform values match colum

    Hi everyone,

    New to VBA here. I have an IF statement in my userform that checks whether certain inputted values match values that already exist on a sheet. This used to work but for some reason it is giving the error listed in the title.
    My code is:

    Please Login or Register  to view this content.
    I can provide more code if needed but is there a formatting/syntax error that would cause this? I also checked to see if these column names exist in the sheet and they do.

    Thanks!

    -shasabhi1

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: Invalid Number of Arguments Error 1004, If statement checks if userform values match c

    Looks ok to me.


    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Replies: 4
    Last Post: 08-31-2017, 02:52 PM
  2. [SOLVED] Compile Error: Wrong number of arguments or invalid property assignment Error
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-22-2016, 05:29 PM
  3. [SOLVED] wrong number of arguments invalid or property assignment error
    By uduyt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2013, 07:40 PM
  4. Compile Error: Wrong number of arguments or invalid property assignment .... help!
    By powercell99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2013, 03:30 PM
  5. [SOLVED] Compile Error: Wrong number of arguments or invalid property assignment
    By bobmaucher in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2013, 12:41 PM
  6. wrong number of arguments invalid or property assignment error
    By uduyt in forum Access Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2012, 08:39 AM
  7. Replies: 1
    Last Post: 02-17-2006, 12:10 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