• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Customer Form

B

BillyRay

New Member
Can someone please create input form with easy to understand vba to edit customers or add or delete customers?

Thank you
 

Attachments

  • Book1.xlsm
    20 KB · Views: 7
Thank you for an amazing solution.

What if there are more customers than the area on the form? Will there be a scrolling ability?

Also this form seems to be universal. Can it be copied for different purposes? Same number of fields that the user can change the labels.

Initially I can see the need for 5 more forms like this.

I really appreciate you @Belleke
 
Last edited:
What if there are more customers than the area on the form? Will there be a scrolling ability?
Click to expand...
Yes, it is a table and a table is dynamic.
Also this form seems to be universal. Can it be copied for different purposes? Same number of fields that the user can change the labels.
Click to expand...
That is possible, in the vba editor drag the userform to another file and copy the data sheet to the this file. Then you can change the names of the column headers and the labels in the form.
Anyway we are here to help you.
 
Can VBA accomplish copying to have multiple forms within same workbook?

Or does it have to be done manually?
 
Yes you can have multiple forms in the same workbook but the they have to have a different name.
an easy way to do this, open a new excelfile, drag that form to the new excelfile, tername the form and drag the form with the new name back to your workbook. (then you can delete the new file)
There wil be a few minor adjustments needed in the vba code to manually.
You can post an example with 2 tables, and I'll make an example and comment were the adjustments are took place
 
Okay I added data sheets like the one you have.

Thank you for your excellent help.
 

Attachments

  • Form Template V1.1.xlsm
    58.5 KB · Views: 3
Last edited:
As attachment example with 5 userforms (working)
If you change the sheet names then you have to change that in the code of the forms, thats all.
For the rest, you can change column headers in the tables and label captions in the forms or the buttons captions in the entry sheet or the titels of the forms , it doesn't make any difference for the working of your file.
I don't know your knowlege of VBA, before I make screen shots let me know if you know how to do it.
If not just ask.
 

Attachments

  • Form Template V1.1.xlsm
    81 KB · Views: 12
Thank you. As far as knowledge I am trying to learn. I do believe this method of userforms can benefit me in so many ways. I really appreciate all that you have done.

Also this should be posted so others can benefit.

Have a wonderful day.:)
 
You must log in or register to reply here.
Back
Top