Moving from Find/Replace dialog to vba editor?

teachman

Active Member
Joined
Aug 31, 2011
Messages
321
Hello,

I have been doing a lot of find/replace of the same phrases on a lot of vba scripts and am finding myself repetively moving my hand to my mouse to move from the vba editor to the find/replace dialog. It has gotten very old and slows down my work flow. I was wondering if anyone knew of a keyboard shortcut(s) that can be used to move from the vba editor to the find/replace dialog and back to the vba editor?

Thanks,

George Teachman
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Control H does get me into the find/replace dialog but doesn't get me back to the vba editor. So far, what I've stumbled upon are the following steps. Ctrl-H do the find/replace Alt-Tab (to some other window) Alt-Tab (back to Excel and the vba editor) do further stuff Ctrl-H (to start the process over again) Thanks, George Teachman
 
Upvote 0
Ctrl-H to get Find-Replace.
Esc to get back to the editor.
 
Upvote 0

Forum statistics

Threads
1,215,692
Messages
6,126,228
Members
449,303
Latest member
grantrob

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top