Forum Discussion

JackieH's avatar
JackieH
Copper Contributor
Apr 16, 2025

Built In Data Form. Can it open automatically when the workbook is opened

Hello, I am trying to keep the built in data form sheet open or set it as a static page. I will have multiple co-workers using this form to plug in data, but would like the to use the form for entries and updates without going into the excel worksheet line by line. 

excel

1 Reply

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Apr 16, 2025

    To my understanding Excel built-in data form cannot be set to open automatically when the workbook is opened, as it is not designed to function as a static page. Below are some suggestions as a workaround by VBA:

     

    1. Open the VBA Editor:

      • Press Alt + F11 to open the VBA editor.
      • Go to Insert > UserForm to create a new form.

    2. Design the User Form:

        • Add text boxes, labels, and buttons to replicate the functionality of the built-in data form.
        • Use the toolbox to drag and drop elements onto the form.

    3. Write VBA Code:

          • Add code to handle data entry and updates:
    Private Sub SubmitButton_Click()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Sheets("Sheet1")
    ws.Cells(ws.Rows.Count, 1).End(xlUp).Offset(1, 0).Value = TextBox1.Value
    MsgBox "Data added successfully!"
End Sub

     

    4. Set the Form to Open Automatically:

    •  
    Private Sub Workbook_Open()
    UserForm1.Show
End Sub