+ Reply to Thread
Results 1 to 13 of 13

How to reset Find Dialog Box

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Lightbulb How to reset Find Dialog Box

    Hi forum experts,
    1- Open an excel file.
    2- Press CTRL + F to open Find Dialog Box.
    3- Type "something" into the box.
    4- Look below and see Sheet is default there.
    5- Change Sheet to Workbook.
    6- Then click Find All button to find "something" in the workbook. (It is not important if "something" is found or not)
    7- Then close Find Dialog Box.

    8- Press CTRL + F to open Find Dialog Box again.
    9- Type "something" into the box.
    10- Look below and see Workbook is default there. (It is default because of your last operation above)

    That means, if you change something on Find Dialog Box, excel remember this changing...
    But I dont want this.
    I want to see Sheet whenever I open Find Dialog Box.

    How can I reset Find Dialog Box ?
    Last edited by HerryMarkowitz; 11-25-2013 at 03:27 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to reset Find Dialog Box

    This line will reset the behavior:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to reset Find Dialog Box

    I want to reset all things on the Find Dialog Box.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to reset Find Dialog Box



    Then just change Workbook to Sheet in the dropdown.

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to reset Find Dialog Box

    I continue searching...
    This link could be good to start.
    http://www.vbaexpress.com/forum/cont...settings-issue

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to reset Find Dialog Box

    OK, good luck.

  7. #7
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to reset Find Dialog Box

    I found the following link which explain, "How to Set Defaults for the Find and Replace Dialog Box" in access.
    http://support.microsoft.com/kb/208923/en-us

    But I need excel code not access

  8. #8
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to reset Find Dialog Box

    This is for Access.
    http://www.vbaexpress.com/forum/show...-quot-Defaults
    I need for excel?
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  9. #9
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: How to reset Find Dialog Box

    If you are going to change all the settings on the find box, why does it matter what they are initially?
    If you aren't going to change them all, then the last used setting should be a help.

    You can set the defaults that you want by invoking the box with code.
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  10. #10
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to reset Find Dialog Box

    Mike.
    There are 3 different dialogs;
    1-
    Please Login or Register  to view this content.
    2-
    Please Login or Register  to view this content.
    3- Dialog Box opened by clicking Ctrl + F.

    I want Ctrl + F dialog box. Because it includes ThisWorkbook option.

  11. #11
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: How to reset Find Dialog Box

    Numbers 1 and 3 are the same on my Mac (the arguments "what"...etc are optional)

  12. #12
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: How to reset Find Dialog Box

    These are my Turkish Excel dialogs;
    http://prntscr.com/4xi5x6

  13. #13
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: How to reset Find Dialog Box

    Mac used to have the two tab style of Ctrl-F.

    There is the button that will switch from the Find(only) dialog box to the Replace.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Customized find dialog box
    By naveen_g in forum Excel General
    Replies: 0
    Last Post: 01-20-2012, 04:15 AM
  2. FIND AND REPLACE DIALOG BOX
    By MoreGOOFS in forum Excel General
    Replies: 1
    Last Post: 06-24-2006, 07:50 AM
  3. Find Dialog Box
    By Elaine in forum Excel General
    Replies: 5
    Last Post: 06-22-2006, 03:10 AM
  4. Find all results dialog box
    By Judy F in forum Excel General
    Replies: 5
    Last Post: 02-01-2006, 07:10 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