S2 - make & copy heading from database sheet then paste it on below of entry form page.
S3 - fill the details in boxes of form then in below heading type = then select box.
S4 - fill correct details, then developer --> Record macro ---> Ok
S5 - in database sheet, ctrl+C, copy the the heading data not heading
S6 - ctrl+down left arrow
S7 - developer ---> click on (use relative references)
S8 - in database sheet, select cell below heading, then type - ctrl+alt+V (small window will open of Paste special) then select VALUES (option)
S9 - off the (use relative references) button.
S10 - go to entry form, delete all filled details then click on stop macro recording.
S11 - test it, enter details in form, then go to VIEW tab --> on right side click on macro --- select - View Macro. ---- RUN. The entered details will be on database.
S12 - create a submit button then assign macro by right clicking on mouse.
Done.
S13 - for clear button - details should be filled on form,
Run Macro - delete all filled details in form, then stop macro recording. Make a CLEAR button - assign macro2.
0 Commentaires