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

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

[Peo Sjoblom]

Check your earlier post for a possible answer

--
Regards,

Peo Sjoblom


"shajueasow" <[email protected]> wrote in message
news:[email protected]...
> 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.

[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

"Peo Sjoblom" wrote:

> Check your earlier post for a possible answer
>
> --
> Regards,
>
> Peo Sjoblom
>
>
> "shajueasow" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>