Me.Controls.Add returns "Compile error, method or data member not found"

**mattisch** · 06-28-2007, 07:14 AM

I have tried different methods of adding checkboxes, but everytime the code includes Me.*something*
and everything i call it, i get "Compile error, method or data member not found.

Example
"Compile error, method or data member not found"

Set chkBox = Me.Controls.Add("Forms.CheckBox.1", "chkCheck" & nNoOfCheckBoxes, True)

**Simon Lloyd** · 06-28-2007, 07:53 AM

Thats because ME refers to the object that the checkbox is in so if the code is in a worksheet module it refers to me.controls.....etc if you want to refer to it in another module or procedure you have to refer to it like Worksheet1.Controls....etc!

Hope this helps.

Me.Controls.Add returns "Compile error, method or data member not found"

LinkBack

Thread Tools

Rate This Thread

Display

Me.Controls.Add returns "Compile error, method or data member not found"

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions