Is it possible to create a userform that will allow poeple to search a protected document?
Is it possible to create a userform that will allow poeple to search a protected document?
Hello mitelkm,
The short answer is yes. Implementation is another matter. The main function you will want to use, assuming your searching an open workbook, is Find for a Range. You can add text boxes to your user form to input the find options and make it easier and faster to change the search parameters.
Sincerely,
Leith Ross
Take a look at the databaseform example here
http://www.excel-it.com/vba_examples.htm
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks