How can I show a VBA UserForm automatically when Excel workbook opens? [duplicate]

Question

I have a UserForm named sira_main in the workbook sira.xlsm, but it does not open automatically when I open the workbook.

I tried putting this code into the General Declarations section of the main sheet, but it doesn’t work:

Call sira_main.Show

Here is an image of the VBA project window:

How can I make the UserForm show automatically when the workbook opens?

Welcomee to SO! Please read How to Ask then improve question! E.g. never show code as image! Always show code as text formated as code as we want to copy and paste it!. Also the Callstatement is obsolete, a simple sira_main.Showis sufficent. — ComputerVersteher
– ComputerVersteher, Commented Sep 20, 2020 at 1:49
This post contains implicitly several questions. Also the code shown in the image cannot run at all as it will not compile based on the posted screenshot. Please also re-phrase your post to a question because but doesn't work is not a question and also not helpful. For possible answers look at stackoverflow.com/questions/53425919/… and stackoverflow.com/questions/53544947/… and contexturesblog.com/archives/2011/06/03/… — Storax
– Storax, Commented Sep 20, 2020 at 6:31

Light · Accepted Answer · 2020-09-20 01:32:13Z

2

Call it when workbook open event happens (in ThisWorkbook):

Private Sub Workbook_Open() Call sira_main.Show End Sub

answered Sep 20, 2020 at 1:32

Light

1,3341 gold badge9 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

ComputerVersteher Over a year ago

Call statement is obsolete, a simple sira_main.Showis sufficent.

chris neilsen Over a year ago

And good practice would be to create an instance of the form an show that

Light Over a year ago

@ComputerVersteher Got it! I can't remember if I once knew that call is obsolete. I just code following what I learnt from the book (and there is call in the example code).

ComputerVersteher Over a year ago

@chrisneilsen by far more important, but without a proper link, users won't know why not to use UserForm1.Show!

Light Over a year ago

@chrisneilsen Since I've only created small VBA projects to help my own work, haven't code that carefully. And this is the first time I know new in VBA. I'll dig into that.

Collectives™ on Stack Overflow

How can I show a VBA UserForm automatically when Excel workbook opens? [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related