UserForm for Similar Entries

[DomSza]

Wasn't quite sure how to title this thread, but I'll try and explain what I'm trying to do the best I can.

I've built a spreadsheet to act as a database for customer information. This data includes company names, identifier codes, contact names, addresses, phone numbers, emails, blah blah everything you can think of. All of this information is arranged with a PivotTable to make it easy to access.

I built a UserForm to help ease data entry, but I'm running in to a UX problem. For example if I wanted to add a new contact for a customer we already have information for, I would need to input ALL the customer information (addresses, account managers etc) just to add an extra person. This adds a whole lot of extra legwork to find all the info.

I'm trying to edit my UserForm in a way so that the user can load a current customer's information, over type and save it to a new line in the source data.

Here's a screenshot of my current userform, and below is the code I'm currently using to input new data. Please feel free to ask questions, I probably haven't explained it very well! I don't know a huge amount about VBA coding, so explanations on how to implement the code would be very helpful.

Thanks,
Dom

VBAHelp.PNG

Please Login or Register  to view this content.

[bakerman2]

That's a lot of lines of code for one userform
Is there a unique identifier for every customer you enter ? That way you can by entering that identifier lookup all data about an already entered customer.

[DomSza]

Hi Bakerman,

Thanks for your reply. I've revised my code and removed some of the unnecessary lines - but I'm happy for suggestions on how to slimline it further. Unfortunately the are not unique, they are used to help filter in to categories.

I thought about using Customer Number, as they are all unique, but not every entry has one.

Thanks,
Dom

[bakerman2]

Please post example workbook for reference including userform and worksheet layout.
Since there isn't a unique identifier a concatenation of Surname and Forename might work to lookup existing customer.