Create simple interactive macro

**mcbarker** · 12-09-2009, 01:19 PM

I'm a novice at macros and don't know VBA, so I'm hoping someone can help me set up a simple interactive macro. I want to create a macro that will disable protection on the sheet, copy a row, insert the row, then bring up the find/replace window for user input, then continue with the macro. The only part I can't figure out is how to bring up the find/replace window for user input and then continue with the macro. Can this be done using Excel tools or would I have to learn VBA? Could you provide some guidance on the steps needed to accomplish this? Thank you.

**Leith Ross** · 12-09-2009, 03:03 PM

Hello mcbarker,

Welcome to the Forum!

Here is a macro that will display the Find/Replace dialog.

Please Login or Register  to view this content.

**mcbarker** · 12-09-2009, 04:38 PM

Thanks for the quick response. However, since I'm really ignorant about the code language, it will take me some time to translate the answer into something I can understand. For example, I have no idea why "1849" is used or what it means. Is there some reference material that would explain what these words and code mean? I've been going through some training on the internet all day, but haven't found a list of code words and explanations yet.

**Leith Ross** · 12-09-2009, 05:47 PM

Hello mcbarker,

The 1849 is the ID number of the "Find..." control on the "Edit" menu. The menu controls can be accessed either by name, menu position (index), or by their system id number. The code searches all menus for the "Find..." control. When it locates the first instance of the control, the object variable cbCtrl (Command Bar Control) is set to point to the Find/Replace code routine. The Execute method then displays the system Find/Replace dialog.

There are 2 authors you should research: Steve Roman, and John Walkenbach. Both have written several books about VBA. They provide examples of real life code along with easy to understand explanations. Of course there are more books about VBA, these authors are two that like.