Dear excel experts,

Can you help me with the following please.

I am just a beginner to VBA. I have created a two userforms. One is for adding data into worksheet and the other one is to search for the record and display them. I could do for the adding part however I am stuck at searching part.

What I have created in the search form (formsearch) is a textbox (textbox) and a button (search). If the key I enter in the textbox match with the records in a particular column then all records in that row should display in a new userform, if there are multiple matches are there then all of them should be shown up.

Many thanks in advance.