VBA to Open userform on Workbook Open event

I have one task that should open one workbook after that one user form has to be open then the user has to enter data in the workbook to the  user form but to see the data the user wants to  scroll down the work book but while running we can’t access the workbook , Is there any way ???? to do this task ,  some one can help me!!!!

Contributor Asked on December 21, 2016 in VBA: User Forms.
Add Comment
1 Answer(s)


You can show the user form in the workbook open event. Please see the below example, this will show the UserForm1 as a modeless(i.e. It will allow the user to access the worksheet when the form is open).

Private Sub Workbook_Open()
UserForm1.Show (modeless)
End Sub



Keymaster Answered on December 21, 2016.

Thank you so much!!! for your  response!!!

i will try this !!!

on December 30, 2016.
Add Comment
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.