VBA

S

Simon

Does anyone know the VBA code for automatically opening a
user form when a document is opened?
 
D

Dave Lett

Hi Simon,

See the VBA help file for auto routines. For this, you'll probably want to
create an AutoOpen routine, as in the following:

Public Sub AutoOpen()
Load myUserFormName
myUserFormName.Show
End Sub

HTH,
Dave
 

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

Turning off automatic calculation 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Word vba 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
ASK Field Formatting 1
CRM concept 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Macro warning in word 1

Top