hello again,

today a pretty tricky question.

I want a sort of search function to change the rowsource of a selectionbox.

so for example, if I type "aft" in a textbox, I want the selectionbox to only show cells from my database that start with "aft" in the description column (let's say column B).

so if in column B there are 5 cells with a value staring with "aft", I want the selectionbox to only show those 5 options.

followup question to this one:

After selecting one option from the selectionbox, I want to copy the row that that cell is in, so that I can paste it in another sheet.