How to activate "New" tab in Dataform through VB Code

S

shajueasow

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.
 
S

shajueasow

Hi Peo Sjoblom,
It was my mistake, my account in hotmail expired and was not able to get the
response. But now I got the answer and it was terrific.
Thank You
 
Top