VBA codes to fully automate Data Entry Form

[jojo4santa]

Hi VBA Experts

Hope you have a good day.
I need your intelligence please.

Attached is The Automated Data Entry Program that has 2 sheets with buttons: Clear, Save, Add Picture, Search.
All the black Fonts are Headings, Labels & Red Fonts are data (either input as new or extracted from backend)
Form (as Frontend) -
Data (as Backend) -

My wish is

1-to turn this Form automated which allows users to either retrieve data from backend (Data sheet) or input data into (Form sheet)
2-cells for data entry must allow users to enter multi-lines like the notes format
3-all the data on Form must be printed out on Legal size

I need the VBA for these buttons please.

Thank you so much for your time and kind help. Greatly appreciated!

[6StringJazzer]

Welcome to the Forum jojo4santa !

Thanks for attaching a sample file and describing it in your post.

What is your question?

[jojo4santa]

thanks 6StringJazzer for your quick help. I edited the post.

[torachan]

Rather than the use of a form on the sheet make use of a UserForm and 'structured tables' the combination of the two enables coding to be far more efficient and compact.
As an introduction/explanation - on the form you will see the textboxes and labels are left with their 'default names' - with the 'labels' on initialisation of the form the 'table column headers' are read and the 'labels' take these names - so any change of header will result in the label changing - you will no doubt want a better layout so always keep the label and associated textbox together.
A similar approach is taken with the textboxes - rather than individually coding textbox to sheet cell relationship (taking 50+lines of code) this is done at each control with a three line loop.
To add a new client first press 'CLEAR' to ensure a clean form and activate the 'ADD' button - enter your data and press 'ADD' to transfer to sheet - the rest should be intuitive.

[jojo4santa]

Thank you so much Torachan for your super quick help.
I will edit the post so that it is clearer what I need. As the Form has to extract data from different servers, it is quite struggling. Very time consuming.

[jojo4santa]

Hi Torachan,
Hope you have a better day. I like your idea.
However, we need to print out this form for the specific task (client photo & all details about client).
I just reposted with a new look.
Data on this Form will be partly collected from existing database and new data entry to complete the info.
This Form will be the snapshot of all details about client & its whereabout.
Some data entry cells will have multiple lines Ex: cell D17 might be entered as notes format with
[*]line1[*]line2[*]line3[/LIST]
Thank you so much for your quick help. Greatly appreciated !

[torachan]

I have looked at your edit - sorry I will pass on this challenge - from experience I do not develop apps that involve merged cells and VBA.
There are a multitude of reasons most are well documented on the web without me repeating them.

[jojo4santa]

Hi Torachan

Thank you so much for your explannation. I just finished the project. Smile.
Merry Xmas!