Excel Data Form

[Don Lloyd]

Hi,
Can someone explain the following.
A cell is selected in a standard list with Headers.

The macro below was recorded when clicking Data / Form and the Form
appeared.

Sub Test
ActiveSheet.ShowDataForm
End Sub

If I run (or step thro') the macro error 1004 appears
"ShowDataForm method of worksheet.class failed"

This happened when an user was using Excel2000 and again with me in Excel 97
(also Xl2003)

Don.

 

[Jim Rech]

This problem is discussed here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;213835

--
Jim Rech
Excel MVP
| Hi,
| Can someone explain the following.
| A cell is selected in a standard list with Headers.
|
| The macro below was recorded when clicking Data / Form and the Form
| appeared.
|
| Sub Test
| ActiveSheet.ShowDataForm
| End Sub
|
| If I run (or step thro') the macro error 1004 appears
| "ShowDataForm method of worksheet.class failed"
|
| This happened when an user was using Excel2000 and again with me in Excel
97
| (also Xl2003)
|
| Don.
|
|

 

[Don Lloyd]

Thank You Jim.