Hi,

Range("A1").Select
ActiveSheet.ShowDataForm

The above lines will show the data form in the active sheet in Excel. How
can it be written so that the form is ready to accept new record. (Or as if
the "New" tab in the form is clicked)

Thank You.