I am VERY new to VBA. I have attached a userform that end users will use to record data for the same record at least 3 times. The worksheet will be submitted monthly. The macro button on the first tab opens the userform where all data will be entered. I can get all of the data from the userform to the spreadsheet on the 2nd tab with no problem. The Case# is the identifier for all updates to that row of data. My problem is that i don't know how to retrieve the data into the userform that was already entered for the selected case #. In summary, i would like to retrieve entered data, update the data and submit back to the worksheet. Any help is much appreciated.
66.7 KB Views: 8