Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Check your earlier post for a possible answer
-- Regards, Peo Sjoblom "shajueasow" wrote in message ... 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. |
#3
|
|||
|
|||
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to activate "new" tab in Dataform in EXCEL through VB | Excel Discussion (Misc queries) | |||
Activate Cell | Excel Discussion (Misc queries) | |||
How do I activate sort in Excel? | Excel Discussion (Misc queries) | |||
How do I activate sort in Excel? | Excel Discussion (Misc queries) | |||
Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) |