Allow Editing during macro running

[Hobolord]

Hello,

I have Windows 7 and Excel 2010.

I am attempting to develop a macro for a report, but I need to be able to dump data into the report in the middle of the macro. It isn't possible for the macro to retrieve the data for me because it is on Remote Desktop.

I've tried using a msgbox, but I can't edit any cells while the msgbox is up and if I hit ok, the rest of the macro will run without having the data in the tabs.

Is there any way to pause the macro so that the data can be input and then resume it? I don't really want to have two separate macros.

Thank you,

 

[mumps]

Do a quick Google search for "Modal" or "Modeless". There is a lot of information available.

 

[mole999]

two macros would be cleanest I think, much better separation of events, easier to debug

 

[Hobolord]

Thanks for the input guys! I'll check out userforms, but most likely I'll just do two macros.