I have a workbook which opens on sheet1. Sheet1 is where the user can add their information into the relevant cells and save data by clicking CommandButton1 (form control button) located in Sheet1. This data is saved in Sheet2 (hidden) in the next empty row through 70 columns.
There is a 2nd button located in Sheet1; CommandButton2 which by clicking loads UserForm1. UserForm1 contains ListBox1 and CommandButton3 (Close button).

This is the bit I need. I need ListBox1 (multiselect single) to be populated with columns A and B data from Sheet2. When a selection is made in ListBox1 (by clicking), search through Sheet2 and when both columns A and B match the selection, upload the entire row information back into Sheet1 relevant cells. If the user makes another selection from ListBox1, I need the same to happened.
This way it will make it easier for the user to select and view archived data instantly.

Sheet2 column A contains dates formatted as “dd-mmm-yyyy” and column B contains either “A”, “B”, “C” or “D”.
Dates can sometimes be duplicated but column B will either be “A”, “B”, “C” or “D”. That’s why I need both columns A and B to match the selection made in ListBox1.

As an example: row 10 and row 11 can have the same date 02-Jan-2017 in column A but column B row 10 will be “C” and row 11 will be “D”.

Column A Column B
Row 10 02-Jan-2017 C
Row 11 02-Jan-2017 D


Please help!