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

Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Integrating information from Word to Excel (not mail merge) 1
Word VBA - Want to test if Full Name is NOT Present in document 0
Linking data in MS Word into Excel 5
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Load data from Word into Excel 7
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Confusion over where user templates are stored in Word 1

Top