Creating Customer User Form

**kjelles** · 01-09-2011, 07:27 AM

Hell I wish I knew VBA, but I dont!!!

What I'd like is the following:

A user form starting with customer number, which may be entered directly for the correct customer data to be displayed, but then also a search for finding the customer name.

As the name are written, the selections found should be narrowed on the fly to ASAP the correct found to be picked. As picked the rest of the data should be filled in; Address-1, Address-2, Zip, Place, Country

If not found, add new customer by generating a new customer number.

Then at last the option of which sheet to go to next.

Probably quite simple but obviously very hard for me... :-)

**DonkeyOte** · 01-09-2011, 08:00 AM

Welcome to the Board but please note your thread title falls foul of Forum Rules

Your post title should accurately and concisely describe your problem / requirements.
Use terms appropriate to a Google search.

Given first post etc... I will on this occasion modify for you but please be sure to adhere to the above (and all other rules) going forward.

**jaslake** · 01-09-2011, 08:19 PM

Hi kjelles

What's your data file look like...post an example. Should be able to build a UserForm that

As the name are written, the selections found should be narrowed on the fly to ASAP the correct found to be picked. As picked the rest of the data should be filled in; Address-1, Address-2, Zip, Place, Country

Need to know what the file looks like to build the form.

John

**kjelles** · 01-10-2011, 02:07 AM

Originally Posted by jaslake

Hi kjelles

What's your data file look like...post an example. Should be able to build a UserForm thatNeed to know what the file looks like to build the form.

John

Hi, John & Thanks alot for your interest in helping out here! :-)

Basically I dont have anything yet, just the plan of how it should be working out.

Basically a few customers might for example have the very same comany name, but belonging to different contries. Therefor I'd like to see the search results narrowed on the fly to ASAP be able to pick the correct one.

And at the moment nothing is found I'd like to add a new one.

So basically, first a customer number. If the customer number is known you could type it directly into this box. If not you do the search for the company names. At the moment nothing is found you should be able to add this company as a new customer.

So Customer number - Name - Address-1 - Address-2 Zip code - Place and finally country.

The rest I think should be pretty plain business I'd guess.... :-)

Any similar sheet could be used for an example I'd think... :-)

**royUK** · 01-10-2011, 09:14 AM

There's a Database Form example here

There's always Excel's inbuilt data form available from the Data menu

**jaslake** · 01-10-2011, 12:10 PM

Hi kjelles

I had forgotten about the Database Form royUK refers to. I've used it on several occasions with success. Try it; it may well satisfy 90% of your needs.

John