Access Form In Excel List

[sarabcx]

I created an Access Form while in Excell. No problem. What I am trying to do is when I open the excell file I want the Access Form to automatically open up so that the data will be entered this way. I tried different ways to do this but can figure it out. help

[BrianB]

Use View/Project Explorer in the VB Editor. Doubleclick ThisWorkBook and use the Workbook_Open event - something like this :-

Private Sub Workbook_Open()
    UserForm1.Show
End Sub