• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

VB Macro dialog box has focus

Hello,

I have a template that runs a dialog box on run which allows the user to enter specific details into a form which is then populated into the document itself.
In Word 2003 we could have another Word doc open, copy and paste content from this document into the dialog box - now we have upgraded to Word 2010 it will no longer let us open another Word document while the dialog box still has focus.

Any ideas around this?
0
sbsbats
Asked:
sbsbats
1 Solution
 
GrahamSkanCommented:
By default, Userforms are opened modally. If a form is thus opened, nothing else can happen in the application until it is dismissed.
To change that behaviour, open form with code like this:
myForm.Show vbModeless

Open in new window

0
 
sbsbatsAuthor Commented:
nice one
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now