Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.ShowDataForm !!
Hi there,
Can the DataForm ( called via ActiveSheet.ShowDataForm ) be displayed ready for a New Record input instead of displaying the first Record ? I have used a the Sendkey Method but can't get it to work . Any Ideas ? Regards. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.ShowDataForm !!
Sub MyShowform()
Range("A1").Select SendKeys "%w", False ActiveSheet.ShowDataForm End Sub worked for me. -- Regards, Tom Ogilvy "RAFAAJ2000" wrote in message ... Hi there, Can the DataForm ( called via ActiveSheet.ShowDataForm ) be displayed ready for a New Record input instead of displaying the first Record ? I have used a the Sendkey Method but can't get it to work . Any Ideas ? Regards. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.ShowDataForm !!
Thanks Tom,
Works for me too . I was sending the wrong characters ! Regards. "Tom Ogilvy" wrote: Sub MyShowform() Range("A1").Select SendKeys "%w", False ActiveSheet.ShowDataForm End Sub worked for me. -- Regards, Tom Ogilvy "RAFAAJ2000" wrote in message ... Hi there, Can the DataForm ( called via ActiveSheet.ShowDataForm ) be displayed ready for a New Record input instead of displaying the first Record ? I have used a the Sendkey Method but can't get it to work . Any Ideas ? Regards. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locate ShowDataForm on Screen | Excel Discussion (Misc queries) | |||
ShowDataForm | Excel Discussion (Misc queries) | |||
ShowDataForm method | Excel Discussion (Misc queries) | |||
ShowDataForm how to lock a field ? | Excel Programming | |||
ShowDataForm Initialization | Excel Programming |