VBA code to pop a message and allow user to access the workbook in middle of code

[Balajibenz]

Hi Team,

I have VBA code which works with multiple sheets and have a scenario where user might need to intervene to do some manual changes in one of worksheet in the middle.

what i am looking for is to have a pop-up box where it asks user to do the changes if required and actually allow user to access one of the workbooks that is already opened and once users clicks on ok code should proceed as usual.

I tried to have it as - Msgbox "Please do the manual changes if required"

it is popping up but i am not able to access any of the workbooks that are opened. Can someone help me with this please.

 

[6StringJazzer]

I would suggest creating a UserForm instead of using MsgBox. MsgBox is modal, which means nothing else can happen as long as it is displayed. If you display a modeless UserForm the user can do anything.

However, you have to reengineer your code to be able to resume when the user clicks OK. To help with that I would need to see all of your code, with an indication of what point in the code you want this box to appear.

 

[Micron]

Make the message box Yes/No (change sheet or not?) and if the response is yes, exit the sub. Or just prompt that it has to be taken care of it and Exit Sub.
Vague I know, but you didn't post any code. If you can't access your wb because the rest of your code runs, the above should take care of that. If it's because you opened it hidden, you'll have to unhide it.