Waitin for the user to perform a task

[grautu]

Hello!
My macro deals with two Excel files, which I call for short as Macro_workbook and User_workbook. The first one to be launched by the user is the Macro_workbook and then, from its inside, the user will be welcome by the usual "Open" window, to choose his/her User_workbook for opening and working with.

I need my macro satisfy the folowing two rules, in turn:

• 1. Once User_workbook is open, the macro should provide the user with a timeout, in order for him/her to complete some needed data in the cells of User_workbook.

• 
  2. Then (after completing data) the user should send to the macro an "OK, I'm ready!" signal that completing data is finished an the macro should start its job.

However I have no ideea about how to implement such a timeout and how to introduce an "OK, I'm ready!" signal from the user.

I would appreciate very much, any helpful hint in this matter.

 

[Hermanito]

Are you working with userforms? In that case, you can make them non-modal (it's a property setting of the form, you can change this in the VB Editor). That way, the user can freely do things while your userform is shown, and can simply click a button on the userform to signal he wants to start a macro. You can also provide menus or toolbars if you don't work with userforms.

Maybe you need to provide some more details of what you want to achieve...