+ Reply to Thread
Results 1 to 6 of 6

Compile Error: Invalid Use of Property when creating Userform

  1. #1
    Registered User
    Join Date
    07-12-2016
    Location
    massachusetts
    MS-Off Ver
    excel 2010
    Posts
    41

    Compile Error: Invalid Use of Property when creating Userform

    Hello,

    I have a userform with this code:

    Please Login or Register  to view this content.
    I have a table built out that's intended to be populated by these. If it helps, I have 3 combo boxes that are alraedy filled (chngtypeenter, updateenter, newdeptenter). I'm getting the "Invalid Use of Property" error and unsure why...

    The sheet I'm working on is "DataEntry," my buttons are labelled Enterbtn and Closebtn.
    Last edited by coryjacques; 12-03-2018 at 09:14 AM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,915

    Re: Compile Error: Invalid Use of Property when creating Userform

    What line of coding is highlighted when you get that error?

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    8,958

    Re: Compile Error: Invalid Use of Property when creating Userform

    try changing this
    Please Login or Register  to view this content.
    If that doesn't help, please show where you get the error, rather than letting us guess

  4. #4
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,783

    Re: Compile Error: Invalid Use of Property when creating Userform

    And
    1. where is "End With" in:
    Please Login or Register  to view this content.
    2. what if is nothing to look for ?

    3. what with this "Me....Value" below, for what is this ?
    Please Login or Register  to view this content.
    Maybe this way (?):
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-12-2016
    Location
    massachusetts
    MS-Off Ver
    excel 2010
    Posts
    41

    Re: Compile Error: Invalid Use of Property when creating Userform

    Sorry about that everyone!

    It seems like the issue is here:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    07-12-2016
    Location
    massachusetts
    MS-Off Ver
    excel 2010
    Posts
    41

    Re: Compile Error: Invalid Use of Property when creating Userform

    I Fixed it! I realized I just left a bit off the end of those statements:

    Please Login or Register  to view this content.

+ 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. [SOLVED] assistance in sub filter unique vba getting compile error invalid use of property
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2017, 02:36 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. Compile Error : Wrong no of arguments or invalid property assigned.
    By kkqazi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2015, 07:18 AM
  4. [SOLVED] Compile error: Invalid use of property
    By Phil Hageman in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-04-2015, 06:03 AM
  5. [SOLVED] Compile Error: Invalid Use of Property on stupidly simple code
    By QueeniePie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2013, 11:41 AM
  6. Excel - VBA - Compile error: invalid use of property
    By Ladynerd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2012, 11:22 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