Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to activate "new" tab in Dataform in EXCEL through VB
Hi,
Code: Range("A1").Select ActiveSheet.ShowDataForm The above code shows up the dataform in an excel worksheet. But how it can be written in such a way so that the data form is ready to accept new record.(Or like the "New" tab clicked.) I hope the question is clear. |
#2
|
|||
|
|||
Maybe something like:
Option Explicit Sub testme() SendKeys "%w" Application.DisplayAlerts = False ActiveSheet.ShowDataForm Application.DisplayAlerts = True End Sub (The shortcut for a New record is alt-w (%w in Sendkeys syntax).) shajueasow wrote: Hi, Code: Range("A1").Select ActiveSheet.ShowDataForm The above code shows up the dataform in an excel worksheet. But how it can be written in such a way so that the data form is ready to accept new record.(Or like the "New" tab clicked.) I hope the question is clear. -- Dave Peterson |
#3
|
|||
|
|||
Thanks A lot Dave.
I was trying to get an answer for this for quite sometime. As I am new to this forum I had made a mistake of posting the same question twice. Sorry for that. Your work is well appreciated. "Dave Peterson" wrote: Maybe something like: Option Explicit Sub testme() SendKeys "%w" Application.DisplayAlerts = False ActiveSheet.ShowDataForm Application.DisplayAlerts = True End Sub (The shortcut for a New record is alt-w (%w in Sendkeys syntax).) shajueasow wrote: Hi, Code: Range("A1").Select ActiveSheet.ShowDataForm The above code shows up the dataform in an excel worksheet. But how it can be written in such a way so that the data form is ready to accept new record.(Or like the "New" tab clicked.) I hope the question is clear. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |