Find Facility - On_Click

**thompsy121** · 11-09-2008, 06:37 AM

Hi All,

I was wondering if possible i could use an on_click method to open the find facility in excel. I know it may be easier to use the Edit, Find or Ctrl+F way.

But i have people using excel with no past experience what so ever, and i would like to make it as easy as possible....i.e a click of a button that says "Search".

Thanks,

Marc

**VBA Noob** · 11-09-2008, 06:46 AM

Try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

**thompsy121** · 11-09-2008, 06:49 AM

Thanks for the quick reply VBANoob. Worked a treat.

Appreciated.

**thompsy121** · 11-09-2008, 06:54 AM

Originally Posted by VBA Noob

Try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

Hi VBA Noob,

All three call the find facility fine, however where i enter the find criteria...it does not find them???

Any suggestions?

Thanks

**VBA Noob** · 11-09-2008, 07:01 AM

Are you sure there is nothing to find. Did you try doing the same manually

or you could use code like the below to go to the find cell

Please Login or Register  to view this content.

If it's a table you could use Advance filter

http://www.contextures.com/xladvfilter01.html

VBA Noob

**thompsy121** · 11-09-2008, 07:10 AM

Yes i tried it manually and it worked fine, for some reason the code calls the find facility but does not actually search.

I like the 2nd code you suggested, but i get an error if i type in text that deos not exist.

Can we show a message box saying no record found etc, then loop the process again to start a new search???

Thanks

**VBA Noob** · 11-09-2008, 07:16 AM

Works for me and it's excel built in function so should work

Maybe

Please Login or Register  to view this content.

VBA Noob

**thompsy121** · 11-09-2008, 07:35 AM

Originally Posted by VBA Noob

Works for me and it's excel built in function so should work

Maybe

Please Login or Register  to view this content.

VBA Noob

Thanks for the 2nd option. But to be honest i think they would prefer the first once which it the actual excel find facility. This is for a work project using Excel 97 - will this make a difference.

Thanks again

Find Facility - On_Click

LinkBack

Thread Tools

Rate This Thread

Display

Find Facility - On_Click

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions