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

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.

Check your earlier post for a possible answer

--
Regards,

Peo Sjoblom


"shajueasow" <shajueasow@discussions.microsoft.com> wrote in message
news:F382C641-BDEB-4AE8-A8DD-D2E745857A90@microsoft.com...
> 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.

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

"Peo Sjoblom" wrote:

> Check your earlier post for a possible answer
>
> --
> Regards,
>
> Peo Sjoblom
>
>
> "shajueasow" <shajueasow@discussions.microsoft.com> wrote in message
> news:F382C641-BDEB-4AE8-A8DD-D2E745857A90@microsoft.com...
> > 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.
>
>