Hi,
I am creating worksheet search box to allow user search worksheet name. If only it at least contains part of the name, search function will go to the possibility of worksheet and ask user to verify.
If user click "YES", it will go to the 1st worksheet found contains part of the name. Otherwise, if user click "NO", I want to make search function go to to the next worksheets found part of the name and verify again until the maximum number of worksheets in the workbooks. Only this part, I failed to do it.
Can anyone help me?
Please Login or Register to view this content.
Bookmarks