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

shajueasow

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to activate "new" tab in Dataform in EXCEL through VB	shajueasow	Excel Discussion (Misc queries)	2	May 1st 05 01:21 PM
Activate Cell	Brett	Excel Discussion (Misc queries)	2	March 29th 05 06:20 PM
How do I activate sort in Excel?	[email protected]	Excel Discussion (Misc queries)	1	March 15th 05 10:27 PM
How do I activate sort in Excel?	[email protected]	Excel Discussion (Misc queries)	0	March 15th 05 09:37 PM
Activate a macro to insert a row and copy the formuals from the rows above to the blank row	oil_driller	Excel Discussion (Misc queries)	1	February 11th 05 03:30 PM

All times are GMT +1. The time now is 10:01 PM.

Menu

About Us