VBA macro to find a value in a different tab or sheet in a excel

[arun15jun]

Hi,

I need to create a search box to find a value in a different sheet (in the same excel) and display the entire row in the row below the search box or Like a text box to display the information related to "value".

Thanks in advance for your help

 

[Joe4]

Welcome to the Board!

What is the data range you are searching look like (how is it structured)?
If the value you are looking for always in the first column?
If so, then you do not need VBA at all. You can just use VLOOKUP.