Compile Error: Invalid Use of Property when creating Userform

**coryjacques** · 11-30-2018, 04:09 PM

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.

**6StringJazzer** · 11-30-2018, 04:14 PM

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

**Fluff13** · 11-30-2018, 04:15 PM

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

**mjr veverka** · 11-30-2018, 07:19 PM

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.

**coryjacques** · 12-03-2018, 08:58 AM

Sorry about that everyone!

It seems like the issue is here:

Please Login or Register  to view this content.

**coryjacques** · 12-03-2018, 09:13 AM

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

Please Login or Register  to view this content.

Compile Error: Invalid Use of Property when creating Userform

LinkBack

Thread Tools

Rate This Thread

Display

Compile Error: Invalid Use of Property when creating Userform

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] assistance in sub filter unique vba getting compile error invalid use of property

[SOLVED] Compile Error: Wrong number of arguments or invalid property assignment Error

Compile Error : Wrong no of arguments or invalid property assigned.

[SOLVED] Compile error: Invalid use of property

[SOLVED] Compile Error: Invalid Use of Property on stupidly simple code

Excel - VBA - Compile error: invalid use of property

[SOLVED] Error message: Compile error: Wrong number of arguments or invalid property assignment

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions