Hello,
I have an excel spreadsheet workbook that has multiple tabs. The 2 tabs that I want to focus on is "Requirements" and "Version Control." When a line on the requirement tab is in need of being changed I would like a macro to be pushed and then have a user form appear that has the following fields: Ref #, Req. Level, Requirement Detail (These are column Headers in A, B, C on the Requirements tab). I am pretty sure I know how to make a user form appear with the field names (labels), but what I don't know is how do I grab the active row, and grab what is in column A, B, C for that active row and auto populate the userform with that information into the correct fields. Then when I hit the submit button, it places the information into the tab called, "Version Control," and on the tab, the information should be placed in the next blank line.
Hope this all makes sense, thank you in advance.
I have an excel spreadsheet workbook that has multiple tabs. The 2 tabs that I want to focus on is "Requirements" and "Version Control." When a line on the requirement tab is in need of being changed I would like a macro to be pushed and then have a user form appear that has the following fields: Ref #, Req. Level, Requirement Detail (These are column Headers in A, B, C on the Requirements tab). I am pretty sure I know how to make a user form appear with the field names (labels), but what I don't know is how do I grab the active row, and grab what is in column A, B, C for that active row and auto populate the userform with that information into the correct fields. Then when I hit the submit button, it places the information into the tab called, "Version Control," and on the tab, the information should be placed in the next blank line.
Hope this all makes sense, thank you in advance.
