Search for a string in another sheet
 

Hello everybody
My workbook contains two worksheets named "school and Rct". The school
sheet contains "No and Name" heads in column B and C. I want to search all
(like Ctrl F & findall in excel) for a string in "shcool!Name column" from
Rct sheet . I want the search box to have two columns No and Name; and list
all the names that contain the search string and place the selected No value
in rct!activecell. I would like to search from Rct!sheet only. I don't want
to display School!sheet.
Is it possible with the VB code?
Thank you all in advance.
With regards
Sreedhar