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
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.
Please Login or Register to view this content.
Thank you in advance
Last edited by unley; 07-20-2009 at 11:49 PM.
Do you mean that it will Execute when the work book is opened?
try...in the VB Editor > Excel objects > thisworkbook > module
hope it helpsPlease Login or Register to view this content.
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
do you mean like...
Please Login or Register to view this content.
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
So thank you pike for your time and I hope this can be useful for anyone who wanted this, cheersPlease Login or Register to view this content.
Oh.... thats what you ment ..
a very good example
cheers mate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks