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

CD- a workbook with this example is available on the companion CD-ROM. The file is named %

ROM data form example. xlsm.



0 0

Post a comment