Hi all,

I have created a Userform which populates data into a spreadsheet 'FAD Data'.

What I want to be able to do is populate an MI page for managers to view cases entered between 2 dates using Date Time Picker, (DP10 & DP11).

I'm guessing this would be best to populate a ListBox on the Userform. (I'm new to VBA so let me know if there is a better way)

I want the ListBox to show the Case Ref (column A on 'FAD Data'), Customer Name (B) the Date Entered (C), the Type (H), the Reason (L) and the Case Owner Name (M).

I then have a button which should print out the details in the listbox

Form Items
Date & Time Picker1 - DP10
Date & Time Picker2 - DP11
ListBox - lbFAD
Command Button - cmdSearch
Command Button - cmdPrint

The data is stored on 'FAD Data'

Thanks