When the cell that to be searched is double-clicked , immediate search process is performed. Userform is loaded and the matching cells can be seen as page name and cell address on the userform.
User can adapt this template to your own file. For this, follow the instructions below :
- Open your own file
- Press Alt+F11 keys and open VBE Window
- In left side of VBE window, drag - drop the userform in the template to your own workbook
- Copy the code in the ThisWorkBook field and paste it into this section of your own file.
