Howdy,
I saw a video on NET with a userform where there were a textbox (for word search) more optionbutton and a listbox, where some data are listed, from a database.
In a frame there were 2 optionbutton from which it could be selected if the search was made after the first letter or after any letter in the cell.
Above the listbox there were other optionbuttons next to each column in the listbox. There were header columns in the database in sheet2 (the button from where user was called is in sheet1).
When writing a letter, in the textbox, search was done by the optionbutton of frame1 and only in the column where the optionbutton was checked.
When selecting any other optionbutton, the data selection is restored.
Please someone can help me with such a code?
Thank you in advance.