Creating a Customer List with Userform and Macros

[yawwwn]

Hi guys, I've a huge customer list that is very troublesome when I try to input new clients.
Current:
My client base is sorted by Alphabets, (i.e. if a new client is Alpha Company, I would input his details in 'A' worksheet, Bravo Company on 'B' Worksheet, so on so forth)

New:
I created a Userform (refer to Excel attached), and by keying in the details in Frame 2 of the Userform, if the company is starts with 'A', its details would be generated in a new row in 'A' worksheet. This goes the same for all other alphabets.

For Frame 1 of Userform, which is the search function, when I key in the company ID (For e.g. A-2), the details of A-2 will appear in the UserForm. And when i key in the company name (or part), it will show me the field (or closest field), much like the search function (Clt-F).

Will appreciate any help! Thanks!

[stnkynts]

Please Login or Register  to view this content.

[LeoTaxi]

Maybe this one can help


Kind regards
Leo

[yawwwn]

Hi stnkynts, I tried your codes, it works well! Except for a few things, hope you could help me with it!

1. Searching through Company ID:
(I placed a screenshot in the 'Input' worksheet of the Excel to illustrate what i meant in case i fail at explaining )
By keying in the Company ID, all the details of the company will appear in the UserForm box, and i can make changes to it and click 'EDIT" below. This would edit the details without creating a new row.

2. Searching through Company Name:
Unfortunately, this doesnt work. When part of the company is search, (for e.g. "Alpha" of "Alpha Company"), can it return the cell at which the value is? (i.e. Cell B2 of Worksheet "A")

3. The textbox all worked perfectly! However, if I may just include one more - The checkboxes. If for e.g. Checkbox "T-shirt" and Checkbox "Diary" are selected, it will return "T-shirt/Diary" in Column L

4. Lastly, "Add New" Command Button works excellently but could it close the Userform when pressed? and perhaps take me to the new added row in whatever sheet it was added in? I was also hoping "Clear" button would clear all fields and "Close" button could close the userform.

THanks alot! Really appreciate it.

[yawwwn]

Hey Leo,

Thanks for your help. I tried the macro, however, it returns an error saying:

Compile Error:
Wrong Number of arguments or invalid property assignment.


Regards

[LeoTaxi]

Oeps, little missing of me, solved here


Kind regards
Leo

[LeoTaxi]

and 1 with the checkbox included


Kind regards
Leo

[mike7952]

Heres what you need. Just add your other options to the code

Please Login or Register  to view this content.

[yawwwn]

Hey Leo,

Thanks so much! It all worked as I'd wanted!

Last thing though, could the 'EDIT' feature I mentioned earlier be included as well?


Cheers,
yawwwn

[LeoTaxi]

little bit confusing with the edit but i think you want
to make changes in existing customers, so is done in this one


kind regards
Leo

[yawwwn]

Hey man thanks a whole lot! It works perfectly!

Regards,
yawwwn