So I created a visual basic form to search for data based on my table sheet, it is supposed to search the purchase order and bring the results of the cells involved.
The textbox that I use already has a filter code in it but it only filters me the purchase order and i'd like to see the results of the Table spreadsheets.
I've been trying for weeks to crack the code and i havent been able to do it , so i would highly appreciate it if you could help me with it.
I also need to apply the filter to the billing document cell (column no 10) and the program stops when i try to do it.
finally i created a dates combo box that should be filtering the ETA dates columns, or if theres a way to filter the data between two dates on the ETA column that would be great.
these are the columns that i need to remain hidden when the listbox displays the results
60 pt;0 pt;0 pt;0 pt;0 pt;0 pt;0 pt;0 pt;0 pt;60 pt;60 pt;60 pt;49.95 pt;120 pt;0 pt;0 pt;60 pt;0 pt;0 pt;0 pt;0 pt;0 pt;0 pt;60 pt;60 pt;0 pt;0 pt;0 pt;0 pt
In summary, please help me coding the textbox so that it can display me the complete table in the listbox when i search for data
- i also need help programming the billing document textbox
- relating the ETA date column to the combo box displayed.
I would really appreciate any possible help
Thank You.
Research.png
Results.png
Bookmarks