A general question, so a general answer:

On possibility:
Yes, you should be able to put up a userform and query for the information
desired. Then you can loop through the sheets and use the find method of
the range object to search the sheet for the information.

go to google groups advanced search

http://groups.google.com/advanced_group_search?hl=en

search this newsgroup microsoft.public.Excel.programming

for find multiple sheets

And you should get some previous responses that contain sample code.
--
Regards,
Tom Ogilvy

OneofLittleword wrote in
message ...
I have an excel workbook with 16 different work sheets in it. Can VBA
be used to .....

1. Create a form / query that will first search for a chosen work
sheet then return the requested information?

If this is possible what would be good reading/info on such things.

If it is not possible... What could be used to make use of my existing
excel workbook to do this.


TIA on any info provided.


JAY


---
Message posted from http://www.ExcelForum.com/