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

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
 
A

Alan

I need the user to be able to edit the document while the message box
is displayed.

Alan
 
P

Patrick Molloy

modal is the default value. Modeless allows the user to manipulate excel ...
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA in Citrix. 0
display message box in excel(2003) using VBA word(2003) 0
Custom Document Properties in Word documents and Excel workbooks 13
Open Word Document using VBA in Excel 6
Determine when Word document opens successfully from Excel VBA 2
animated image in user form 2
Access to spreadsheets with VBA User Form up 1
Excel Table Width Pasted into Word 5

Top