How Do I Make My Userform Pop-up At The Begining

  • Thread starter Thread starter doller
  • Start date Start date
D

doller

HOW DO I MAKE MY USERFORM POP-UP AT THE BEGGINING OF MY SPREADSHEET I.
WHEN I OPEN EXCEL THE FIRST THING I SEE WILL BE THE USERFOR
 
We can tell you, but first you have to turn your CAPS LOCK key off. ALL
CAPS is usually considered the equivalent of SHOUTING (and is much
harder to read).


....Ready?

Put this in your ThisWorkbook code module (right-click on the workbook
title bar and choose view code):

Private Sub Workbook_Open()
UserForm1.Show
End Sub
 

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

Back
Top