View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter[_33_] Peter[_33_] is offline
external usenet poster
 
Posts: 9
Default Macro for forms function


-----Original Message-----
Hello, I have a spreadsheet that I want to create a macro
to open the form function (under Data Form). I have not
been able to create a macro to do this. I have received
several different errors. Can someone help show me what
to type in the macro to make it work.

Thanks in advance for all of your help.
.

Try

ActiveSheet.ShowDataForm

Make sure that the cursor is in the data list

Regards
Peter Atherton