Populate userform with data from Excel worksheet and be able to amend the data
I'm a newbie on here and new to VBA. I have been asked to develop a userform to collect data and save it to an excel spreadsheet - which i have managed to do.
I now need to add functionality to the userform to search for specific data range in a column on the worksheet and pull into the userform any related data which has been previously populated via the userform.
I.e - user partially completes the form and saves the data to a worksheet.
When the user reopens the userform and selects (listbox of relevant values) or types in the data string they are looking for, the form automatically pulls in all the data that belong to that record set.
The user can then complete more fields on the form and any changes/updates are saved to the excel worksheet.
I have managed to find bits of code that do different things, but I am struggling to associate the recordset based on the criteria the user enters via keying in or selecting from the listbox.
I feel like I am going round in circles with this and hence the request for help.
Any ideas/suggestions greatfully received
Video Tutorials / Excel Dashboards Reports