Userform - Address Book

Hi

I want to create a address book with certain details (see attached) in excel.
Is there a way to create a "userform" for
- easy data entry ie all required fields are displayed in a "form format" instead of the usual excel column. After data entry, the data are auto-populated in the respective excel columns

- search and view search result. eg if a certain phone number or name is entered into the form, other details will be auto-populated into the form.

Thank you for assisting.

Nancy

Hi Palmetto

I followed your link to create an Data Entry Form and Excel User Fom.

The "Data Entry Form" works fine.

However, the "Excel User Form" can't work. I created a "add contact" button but there's an error.

Please help.

Regards
Nancy

Hello Nancy,

For the code to show the user form, you only have to write the name of the form plus .show

In your case the macro for the button would be similar to below:

Please Login or Register  to view this content.

For some reason I could not edit the code for the rectangle you had so I added my own one.

Hope this helped

Orla

Hi

The attached can't work; that is when I entered all the data and click "Add", there is a error message.

Regards Nancy

Hello Nancy,

I had a look at the code and the text boxes are not named correctly. I was going to send on file but this is the comment I made in it

Please Login or Register  to view this content.

Unfortunately when I changed them another error came up and I do not know how to solve the error.

Sorry I could not help more.

Regards,
Orla

Hi

Thanks Orla.

Can anyone in the forum help me with my "wrong code" and workbook.

Regards

Nancy

Address Book.xlsm

Originally Posted by Palmetto

Excel Data Entry Form

Create an Excel User Form

Hi

I tried but cannot get the correct code.

Kindly help.

Nancy

The code is referencing comboboxes in several instances instead of the textboxes on the form.