Access Form In Excel List

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

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

Code:

---

Private Sub Workbook_Open()
    UserForm1.Show
End Sub

---