I can't get a simple macro to pull up the data form for a
list. The form comes up just fine doing it manually, but
the macro won't. See code:

Sub dataformtest()
'
' dataformtest Macro
'
ActiveSheet.ShowDataForm
End Sub

I've done all the right things to make the list
identifiable to excel (format outline the list, different
text format on label at top of list); and it works fine
as I said when I use menu bar: Data then Form. Thanks.

Randall

http://support.microsoft.com/default...35&Product=xlw

--
Jim Rech
Excel MVP