February 3, 2021
So i created a user form based off a quarterly schedule. It has employee name and id and blah blah. When you get to 1st QTR of 2021, you can select the cell by the persons name and under the row QTR1, and you can select pass,fail,LOA, etc. When you select anything in that cell, it calls for a userform to popup.
That user form has a lot of the same information that is in that row, and i want to make the userform autofill in that data, on that row, based off of the cell that you selected.
I have had no training for VBA. I am figuring it out as i go, so please excuse the lack of knowledge.
By selecting an outcome in cell from a data validation drop down menu (pass/fail)
it triggers a user form i created in vba.
I want the data that corresponds with that cell to autopopulate the first couple entries on that user form (so i'm selecting row 2 column d and i want it to pull data from row 2 column a, b, c and put those in the correct fields.
Any suggestions on what kind of code to do...and biggest this, is there something like a .user.select ref range A or something so it says where he selects, is the row we get the info from.
Hope this makes sense. i wish i could share pics, but I am not allowed to. Thank you for understanding.
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013