View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randall[_4_] Randall[_4_] is offline
external usenet poster
 
Posts: 4
Default macro won't pull up list's data form

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