macro won't pull up list's data form

  • Thread starter Thread starter Randall
  • Start date Start date
R

Randall

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
 
Back
Top