To close the dialogue box with just keyboard:
Esc or
Alt+F4
will work. Using XL2003, I was not able to get Alt+F6 to switch windows
either.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"teelee" wrote:

Yes this is what I was after, however when I press Alt + F6 nothing happens,
it just stays on the find/replace box.

Thanks

"xlm" wrote:

Do the following
when you have your Find/Replace executed
press Alt + F6, this will bring the focus back to the worksheet

if you are on a sheet and want to move to another sheet,
press Ctrl + Page Up / Page down

to bring focus back to your Find/Replace
press Ctrl + F

Is this what you are after?

HTH
--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"teelee" wrote:

Yes I understand that but what I was trying to avoid was using the mouse from
going to find and replace to my worksheet. I know once I'm in the worksheet I
can use ctrl f which brings me back to the find & replace, but is there away
to go from the find & replace to my worksheet without using the mouse?

Thanks

"xlm" wrote:

Hi teelee

Assuming you are on sheet3 while already executed the Find/Replace dialog
and want go to sheet1, you need to click on the sheet tab of sheet1 and
EXcel will bring you there without the need to close the Find/Replace.

HTH
--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"teelee" wrote:

When I tab it's stays at the find and replace box. What do you mean the sheet
tab?

Thanks

"Luke M" wrote:

Either click the close button if you want it to go away, or select the sheet
tab in Excel. The find & replace box will become passive while you navigate
in XL.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"teelee" wrote:

If i'm in the Find and Replace box how do I go back to the worksheet that I'm
working on?

Thanks in advance