When the attached workbook's userform is opened, data is entered in the textbox and is saved to Sheet2 when the save button is pressed. Is there any additional code that I can include that can do the below:
After data is entered for any line of data, the save button is pressed and does the below:
1. Data saved to the record in sheet2 (the form already does this)
2. Send the entered data to the listbox so it is visible (i.e. updated) in the listbox in the relevant line
One way to show the new data in the listbox is to use code to close the form and then reopen the form but I don't want to use this method.
Would appreciate your input!
Bookmarks