Results 1 to 5 of 5

Add a "Find" Button to Excel (VBA?)

Threaded View

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Add a "Find" Button to Excel (VBA?)

    This probably sounds stupid because I can just CTRL-F but my other employees are not understanding of Excel. Right now I have macros in my sheet that apparently turn MATCH CASE and MATCH CELL on, and leaves them on.

    So when doing CTRL-F it defaults with both of those on..then you can't find data. I can't determine where this happens to simply turn it off, but I wanted to make a FIND button anyways because they often don't remember how to hit "CTRL-F" either.

    So..simple solution would be a button that just activates a box to type a value and find it without case or cell sensitivity.

    Any pointers? I searched google and here but found nothing like it.

    Thanks in advance.

    Edit
    (Looks like match case saves into the document..explains why it was doing that...woops. Still would like button though)
    Last edited by NewYears1978; 03-25-2014 at 11:01 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Emulate Excel 97 getopenfilename "Advanced" find including "Search subfolders"
    By FORTRANguru in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2014, 08:21 PM
  2. Countdown Timer in Excel with a "pause" and "start" button
    By bbhagwat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2013, 05:49 AM
  3. Create a Command Button to "Save As" and "Close" an Excel Workbook
    By thedunna in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-26-2013, 05:38 PM
  4. programming code in macro "to find other excel" by clicking a button
    By sanjeev devaliya in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-25-2013, 12:11 PM
  5. Replies: 5
    Last Post: 06-26-2006, 09:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1