Programming Excel with VBA and .NET

Data Forms from Code

To display a data form from code, take these steps:

1. Get a reference to the worksheet containing the data-entry range.

2. Call the ShowDataForm method on that worksheet object.

The following code displays the data form for the DataForm worksheet:

    Sub ShowDataForm(  )
        Dim ws As Worksheet
        Set ws = Worksheets("DataForm")
        ws.ShowDataForm
    End Sub

Figure 20-5. Using a list of values for validation

Figure 20-6. Values from the validation list appear in a dropdown

The data-entry range should be contiguous. Blank rows or columns within that range cause problems entering new records.