ActiveSheet.ShowDataForm !!

[RAFAAJ2000]

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.

 

[Tom Ogilvy]

Sub MyShowform()
Range("A1").Select
SendKeys "%w", False
ActiveSheet.ShowDataForm
End Sub

worked for me.

 

[RAFAAJ2000]

Thanks Tom,

Works for me too . I was sending the wrong characters !

Regards.