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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to activate "new" tab in Dataform in EXCEL through VB 2
Populate dataform with combobox1.value 2
Dataform opening on startup, and validation list in form? 2
Dataforms 3
Error Running a Macro 3
Macro to bring up Data Form 1
Activating hyperlinks 3
Excel VBA - Problem with Closing Print Preview 0

Back
Top