[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

VB Macro dialog box has focus

Posted on 2013-11-11
2
Medium Priority
?
337 Views
Last Modified: 2013-11-12
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
Comment
Question by:sbsbats
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 2000 total points
ID: 39641007
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
 

Author Closing Comment

by:sbsbats
ID: 39642807
nice one
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question