View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T. Londrigan T. Londrigan is offline
external usenet poster
 
Posts: 1
Default Want to create a search gui on wkst1 to seach data on other wksts

I'm pretty sure if I was a VB developer this would be easy, but unfortunately
I'm not -- so any help would be appreciated.

I'd like to build a search gui on the first worksheet of a spreadsheet
containing only a text box for the user to type in the search string and a
pushbutton to submit. The data can be on any number of other worksheets
within the spreadsheet. I'd like to jump to the wkst to show the row of data
found with the matching text, then I guess the user can do findnext to
continue searching if needed.

Thanks,
Terri