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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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,214,807
Messages
6,121,679
Members
449,047
Latest member
notmrdurden

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