"Invalid use of ME keyword" when trying to loop through all userform controls

**max3732** · 03-02-2012, 07:09 PM

I have a userform with textboxes as well as other objects. I'm working off a textbook and it uses similar code in the chapter. When I'm trying it I'm getting the error message "Invalid use of ME keyword"

Please Login or Register  to view this content.

I also looked up online and tried copying and pasting their code and got the same error message

**shg** · 03-02-2012, 08:25 PM

This is in the code module for the userform, and not in a standard module, right?

**max3732** · 03-05-2012, 10:17 PM

Your right, I put it in the from module.

**davesexcel** · 03-06-2012, 08:12 PM

Can you attach a sample workbook with the offending code?

**royUK** · 03-07-2012, 03:10 AM

This works fine for me.

Note: MSForms.Control

Please Login or Register  to view this content.

I can't understand why you are using this code in the Initialize event, the default value of the textBoxes wil be empty when the form loads

"Invalid use of ME keyword" when trying to loop through all userform controls

LinkBack

Thread Tools

Rate This Thread

Display

"Invalid use of ME keyword" when trying to loop through all userform controls

Re: "Invalid use of ME keyword" when trying to loop through all userform controls

Re: "Invalid use of ME keyword" when trying to loop through all userform controls

Re: "Invalid use of ME keyword" when trying to loop through all userform controls

Re: "Invalid use of ME keyword" when trying to loop through all userform controls

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions