Getting an error "Method or data member not found" Help Please and thank you

Im trying to create a form with buttons to enter data.
i am new to visual basic so please explain any answers in detail.

Please Login or Register  to view this content.

Hi, bnielson,

welcome to ExcelForum. Please have a read at Forum Rule #3 and add code-tags to your procedure prior to us having a look at the code.

And please consider to attach your workbook to have a look which would make answering a lot easier.

Ciao,
Holger

Hi, bnielson,

just from looking at the code I can´t find the reason why any error should occur as you don´t specify which error number is shown (worksheet not avaialble or trailing blanks behind name, worksheet protected, merged cells). That´s why I asked for a sample workbook.

BTW: is your sheet called "IP Address Book>"?

Ciao,
Holger

There's no control on the userform with the name txtEquip, or txtEqui, or txtIP, or txtSub, or txtGate.

The controls are there, they just don't have the right names.

Hi, bnielson,

only txtSite has been renamed accordingly. You would need to open the properties window via F4 in the VBE and change the names for Textbox1 to Textbox4 accordingly to match your code or adapt your code to match the names of the Textboxes.

Ciao,
Holger