Macro for forms function

  • Thread starter Thread starter Shawn
  • Start date Start date
S

Shawn

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.
 
-----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.
.
Click to expand...
Try

ActiveSheet.ShowDataForm

Make sure that the cursor is in the data list

Regards
Peter Atherton
 
ActiveSheet.ShowDataForm

If your data does not start in the first two rows, you will be more
successful if you name the table "database"

Assume the top left corner of your data is in cell M35

Range("M35").CurrentRegion.Name = "Database"
ActiveSheet.ShowDataForm
 
Back
Top