Microsoft Office Tutorials and References
In Depth Information
Displaying a Data Form
Displaying a data form by using VBA
Use the ShowDataForm method to display Excel’s data form. The only requirement is that the
active cell must be within a range. The following code activates cell A1 (which is in a table) and
then displays the data form:
Sub DisplayDataForm()
Range(“A1”).Select
ActiveSheet.ShowDataForm
End Sub
A workbook with this example is available on the companion CD-ROM. The file is
named data form example.xlsm .
 
Search JabSto ::




Custom Search