Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Is it possible to add a Search Box within a spreadsheet?

Is it possible to add a search box within a spreadsheet? For example if you
go the Menu you can click on the Find button and then enter a name; the
function then searches the database and finds matching entries. So I'm
wondering if you can add a similar "Search Box" within the spreadsheet which
will allow the user to simply type in an entry and have the macro find the
matching entries. Hope this is clear...Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 921
Default Is it possible to add a Search Box within a spreadsheet?

Try pressing F5. OR Ctrl + F, Or are you looking for a strictly programmatic
approch? In which case use the help file in vbe and search .Find Method.

"JRSCEI" wrote:

Is it possible to add a search box within a spreadsheet? For example if you
go the Menu you can click on the Find button and then enter a name; the
function then searches the database and finds matching entries. So I'm
wondering if you can add a similar "Search Box" within the spreadsheet which
will allow the user to simply type in an entry and have the macro find the
matching entries. Hope this is clear...Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding a search box to a spreadsheet Adding a search box to a spreadsheet Excel Worksheet Functions 1 November 30th 08 11:19 PM
How can you search by column or row within a spreadsheet? Brandy Excel Worksheet Functions 5 September 12th 08 05:11 PM
Search Spreadsheet for a name missy Excel Discussion (Misc queries) 2 December 13th 06 11:53 PM
Search Spreadsheet - Results in either listbox or new spreadsheet Brandon Johnson Excel Programming 1 June 7th 06 03:19 PM
Add Search Box to Spreadsheet Excel User Excel Programming 1 August 3rd 04 09:18 PM


All times are GMT +1. The time now is 03:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"