[Last Call] Learn how to a build a cloud-first strategyRegister Now


Word VBA - Programmatically close modeless form

Posted on 2011-04-27
Medium Priority
Last Modified: 2012-05-11
Hi Experts
Is there a way to programmatically close a modeless form?  I have a modelss form containing context relevant data.  It sits in the corner of the screen whilst the user is working.  If the user runs certain functions, I want the form to either close or perhaps refresh the data using a new source.  Is it possible to do either or both of these things?
Thank you for your help.
Question by:MonteDelMar
LVL 76

Accepted Solution

GrahamSkan earned 2000 total points
ID: 35476909
For closing

Unload UserForm1

or UserForm1.Hide

For new data

UserForm1.TextBox1.Text = "New Text"


Author Closing Comment

ID: 35477130
That easy!! I have spent hours looking for a much more complicated way to do it.  :-)  Thanks again, Graham

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

It is often necessary in this forum and others to illustrate Word fields as text with the field delimiters replaced with the curly brackets that the delimiters resemble when field codes are being displayed on the document. This means that the text c…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
Suggested Courses

829 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