Viewing Excel VBA-generated User Form (modal) in Word

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Using Excel VBA I create a new Word document and paste some content.
I then want the user to review the resulting document and press
Continue for some additional processing. To do this, my Excel VBA
code displays a modal user form with a Continue button.

However, when the user form is displayed, the Excel spreadsheet is
displayed, instead of the Word document. It does not let me switch to
the Word document with the user form displayed. (I click on Word on
the Task Bar, but the display does not change.)

I am using Excel 2003 and Word 2003, running on WindowsXP.

Any ideas on how to get around this? Alan
 
I get the same results with both modal and non-modal user forms. It
does not let me switch to
the Word document with the user form displayed. (I click on Word on
the Task Bar, but the display does not change.)

It must be an Excel vs. Word issue. Alan
 
Back
Top