Hello,
I'd like to make a userform with a textbox, command button and listbox. Enter text into the textbox and click search, then the list box displays 23 columns of data from a worksheet. This is going to be used to query shipments. So the textbox will lookup the customer name in column B, then after searching the listbox will display all rows and columns of data pertaining to that customer (so columns B through X and however many rows that customer is listed).
Example
Search for QQQ in the textbox, and the listbox would show something like:
QQQ 9/17/16 FedEx $345 etc etc
QQQ 10/20/16 FedEx $345 etc etc
QQQ 11/4/16 FedEx $345 etc etc
QQQ 1/1/17 FedEx $345 etc etc
QQQ 5/7/17 FedEx $345 etc etc
QQQ 8/15/17 FedEx $345 etc etc
I found some code listed on another site that I'm trying to modify but I have no idea if this is the correct way to do this. Plus, I can't figure it out anyway, and I'm also not sure what properties I need to set for the listbox (if any) to make it work. Here's the code:
If anyone knows what I'm trying to do either with this code or using another method, please let me know.Please Login or Register to view this content.
Thanks!
Bookmarks