Hello all...I used to think I was great with excel until I started making VBA userforms. I've created the form and the button to show the form (which does work), but I can't seem to figure out the code to transfer the data from each field to the respective row in the table. It shows I don't have permission to attach screenshots, so I attached a link to them here...
screenshot of table in excel --- https://drive.google.com/open?id=1NqL1KN7iXpkZTq6w-9uwF3YmpVbrDjKP
screenshot of userform --- https://drive.google.com/open?id=1qp8ip1ok9ObOnxQZcGth9LO-QgNCI8bK
What I need specificially...
- All fields EXCEPT the checkbox need to have a value entered or it should present a msgbox saying "You must enter something in every field before saving."
- When you press save item, I need the data to transfer to the next available row and fill into the respective fields. (I know I haven't provided the exact names of each text box but I can fill them in).
- After entry has been saved, I would like the form to close.
I will also be creating another form to pull up an existing entry that will pull up the existing info on that row about the item, and have the ability to change that and save which will over write that data on that row... I haven't started on that yet, because I wanted to try this first.
Any help would be much appreciated!!
-Chance
screenshot of table in excel --- https://drive.google.com/open?id=1NqL1KN7iXpkZTq6w-9uwF3YmpVbrDjKP
screenshot of userform --- https://drive.google.com/open?id=1qp8ip1ok9ObOnxQZcGth9LO-QgNCI8bK
What I need specificially...
- All fields EXCEPT the checkbox need to have a value entered or it should present a msgbox saying "You must enter something in every field before saving."
- When you press save item, I need the data to transfer to the next available row and fill into the respective fields. (I know I haven't provided the exact names of each text box but I can fill them in).
- After entry has been saved, I would like the form to close.
I will also be creating another form to pull up an existing entry that will pull up the existing info on that row about the item, and have the ability to change that and save which will over write that data on that row... I haven't started on that yet, because I wanted to try this first.
Any help would be much appreciated!!
-Chance