Help with VBA Non-Modal process issue

[Alan]

During a process that I step the user through, there are several
points at which I display informational windows that need to be non-
modal. These windows prompt the user to review and/or edit data that
was generated before moving to the next step.

The problem is that a non-modal window is displayed, but then the
rest of my code (implementing the rest of the process) executes. I
want it, instead, to wait for the user to tell the program that he/she
is finished with the [manual] review/edit process. The window has to
be non-modal to allow editing of the spreadsheet under the window.

How do I get around this? Thanks, Alan

 

[Doug Robbins - Word MVP]

You could use a non-modal userform with a command button on it.

However, as you are talking about a spreadsheet application, you should
probably seek assistance in the microsoft.public.excel.programming newsgroup
as this one is for Word.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com