Userform opening, running order in VBA

selant

Board Regular
Joined
Mar 26, 2009
Messages
109
I am working in VBA environment i have 2 forms in the project, when I press F5 to run the scripts, userform2 opens. I want to open userform1 when pressing F5. How to change the order ?
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

RolfJ

Banned
Joined
Jul 29, 2009
Messages
333
When you press F5 VBA always starts with the code that is on top. Try this out: set your VBA to view UserForm1. Now F5 will cause that form to show up first. The way to control which user form shows up first is to create a macro routine in a standard VBA module which then explicitly shows a specific form, e.g.

Code:
Sub Test()
    UserForm1.Show
End Sub
Hope this helped,
Rolf
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,625
Messages
5,512,475
Members
408,899
Latest member
cve60069

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top