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
Bookmarks