MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

froms related

  Asked By: Pamela    Date: Jan 21    Category: MS Office    Views: 1146

I am very new to this excel VBA, my query is I have a form, when I open an
excel this form should open automatically.



3 Answers Found

Answer #1    Answered By: Amelia Schmidt     Answered On: Jan 21

Open the Workbook sheet (code view) and enter:

Private Sub Workbook_Open()
UserForm1.Show 'Where UserForm1 is the name of your userform
Sheet1.Activate 'Where Sheet1 is the sheet you wish the userform to
appear on.

Answer #2    Answered By: Kristen Chavez     Answered On: Jan 21


It is working..............

Answer #3    Answered By: Jennie Harris     Answered On: Jan 21

Write the below code in your ThisWorkbook.

Double Click ThisWorkbook from your VB Editor and Choose Workbook from the
first drop down list in your right hand side.

The you will get WorkBook_Open event.

In that write the below code.


Then Save your workbook, Close and reopen it again. Then your form  will peep
out in front of you.

Didn't find what you were looking for? Find more on froms related Or get search suggestion and latest updates.