I have list of products listed in 1 worksheet. I just wanted to add vba macro to this excel file on a different worksheet. Intention was to hide the long list of products and just create a nice interface.
With a click to commandbox, a userform opens and we have couple of textboxes for input. These two textboxes should search within column A&B separetely or at the same time.
The results should be written to the list box eventually. What I mean listbox should show all columns with matching results.
I couldn't create that search part of it. Can you please help me? Thanks.