Here, you can:
Once you have drawn your ListBox in a UserForm,
Display data from your Database (Worksheet) in the ListBox (Watch the Video).
Display Certain Data Columns in the ListBox (Watch the Video)
Perform a search or filter data in the ListBox (Watch the Video).
Extract data from the ListBox to TextBoxes, ComboBoxes, etc. (Watch the Video).
Transfer data to a worksheet for printing (Watch the Video).
Navigate between rows in the ListBox (Watch the Video).
Search between two dates in the ListBox (Watch the Video).
Concatenate: Combine the values of the ListBox and TextBox into a second TextBox (Watch the Video)
Adjust the format of columns in the ListBox (Watch the Video).
Format columns in the ListBox to (hh:mm) (Watch the Video)
Go directly to the last row in the ListBox (Watch the Video).
Adjust Column Dimensions in a ListBox to Full Screen (Watch the Video)
Restore Column Dimensions in a ListBox to Initial Size (Watch the Video)
Simply, insert the requested value in the box, click on the “Get the Code” button and Hop, the code appears in the square at the very bottom of the page… copy and paste it into your UserForm…That’s it 🙂