+ Reply to Thread
Results 1 to 7 of 7

Possible to call Find & Replace dialogue box within Workbook?

  1. #1
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Possible to call Find & Replace dialogue box within Workbook?

    Yes, another homework for you guys. I have found the code to open the "Find and Replace" dialogue box but is it possible to open it with "within:" Workbook instead of Sheet?

    This is the code that open up the dialogue box

    Please Login or Register  to view this content.
    You know, there are some lazy people that I have to dealt with who can't be bother of clicking on "Workbook" to find what they want.

    Thank you in advance
    Last edited by unley; 07-20-2009 at 11:49 PM.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Possible to call Find & Replace dialogue box within Workbook?

    Do you mean that it will Execute when the work book is opened?

    try...in the VB Editor > Excel objects > thisworkbook > module
    Please Login or Register  to view this content.
    hope it helps
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Re: Possible to call Find & Replace dialogue box within Workbook?

    Thank you for replying pike but it's the same dialogue box I have in the first post but already after choosing Option.lol

    But I would like it to open with the choice of Workbook in "Within:" box instead of Sheet

    I'm going to assign macro with a button so the boss can just click on the button and the "Find and Replace" dialogue box will appear, showing Workbook in "Within:" box

    Thanks

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Possible to call Find & Replace dialogue box within Workbook?

    do you mean like...
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Re: Possible to call Find & Replace dialogue box within Workbook?

    No, this code does'nt open "Find and Replace" dialogue box with "Workbook" in Within: text box.
    But I have found a suitable one while surfed the net. This will open a dialogue box that will search for your text right through the workbook

    Please Login or Register  to view this content.
    So thank you pike for your time and I hope this can be useful for anyone who wanted this, cheers

  6. #6
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Possible to call Find & Replace dialogue box within Workbook?

    Oh.... thats what you ment ..

    a very good example

  7. #7
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Re: Possible to call Find & Replace dialogue box within Workbook?

    cheers mate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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