Copy Contacts VBA ActiveX Code Error

[oskar44]

I download a free contacts DB lesson from Internet and have successfully configured it to my needs (this is a hobby project to improve my VBA knowledge)

In the same workbook I added a new sheet and made a new userform all with ActiveX controls. The VBA project editor consists of these sheets:
Module1
Sheet1 (phonelist), from the downloaded lesson
Sheet2 (Interface), from the downloaded lesson
Sheet3 (MyForm), my new ActiveX form
Sheet4 (MyDB), my new sample DB
ThisWorkBook

I now doubleclick on a control button in my new ActiveX form in order to copy the existing lesson code into this new control (which I will revise to include the references from my new DB) but as an example I get this error.

If Me.txtSurname.Value=””_ (Error says Method or data member not found)

I’m sure this is related because I don’t properly refer to my new ActiveX form. How I can overcome this error?

[Leith Ross]

Hello oskar44,

From what the error is saying, you don't have a control on the user form named txtSurname. Another reason you might receive this error is from executing theis statement from a Worksheet Module like Sheet1. The keyword Me can refer to different objects. It is not solely associated with a VBA UserForm.

[oskar44]

Thanks for your time Leith, I will work it out somehow