Hi everyone
I am very new to excel vba programming and need help with the last piece of info for my project. I have created a UserForm that has txtboxes, comboboxes and command buttons which works on three sheets(DataBase, DataList and PrintableForm). There are six command buttons, Record data: which records data from userForm to DataBase and PrintableForm. Email Form: it emails the PrintableSheet only. Print: prints the printable form. Clear: Clears userForm and PrintableForm after Printing. Cancel: Unloads userForm. Then theres Update which I have a problem with...
In this project the user first enters partial infomation, because it is infomation gathered at the time, I want the update button to be able to first require a Job Card Number from user which is different for each previously entered entry in the DataBase sheet, if the number matches then the userform must be filled with the data in that spreadsheet which is in the same row as the JC Number. Then the user will complete the rest of the form on the userform, then after the last entry if all fields are filled,it should update the original row of data also adding the data that was not present, if the number doesn't match a simple message box should pop up saying try again and X should return user to UserForm...
is all this possible??? thanks a million for your help
Due to privacy and confidentiality and all that issues... I can't post a sample. Hope You can still help.
Bookmarks