Good day all
In the attached example (Which is a bare bones version of my project just for example purposes):
I have created a UserForm which was designed to "look up" information from a worksheet. What I would like is a macro that will allow me to edit data using that same UserForm.
So in examining my example (and I am not even sure if this is even possible) I would like a macro so that when I click the "edit" button, a password prompt appears where a password would be required to edit data (or something of that nature). Then once the data is edited, when the user clicks "update" the data is saved in the same positions/order it was previously saved under the same headings.
It should be noted that I intend to use this function to also add data which I previously could not get at the time of initial input (i.e. I may input student data without the students grade and save, then at a later date, when the grade is ascertained, I use the aforementioned function to add the data).
Any assistance/guidance re this matter would be greatly appreciated.
Bookmarks