I have userform1 with multiple labels that are linked to cells in a worksheet displaying data. On userform1 I have a command button which brings up a second userform with a textbox on it. The user inputs data into the textbox, clicks a command button which puts the data into the worksheet into a cell that is linked to a label on Userform1.
What I want is when the user clicks the command button on userform2 to put the data into the worksheet, that Userform1 refreshes to display the new data without having to close and reopen the userform.
I figured this would be pretty simple but I can't seem to figure it out so if anyone has any suggestions it would be greatly appreciated. Thank you.
What I want is when the user clicks the command button on userform2 to put the data into the worksheet, that Userform1 refreshes to display the new data without having to close and reopen the userform.
I figured this would be pretty simple but I can't seem to figure it out so if anyone has any suggestions it would be greatly appreciated. Thank you.
