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

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

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

the useform should be shown modeLESS


"Alan" wrote:

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

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

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

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

Have a look at the SetParent API.

RBS


"Alan" wrote in message
...
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