Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for forms function
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for forms function
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 -- Regards, Tom Ogilvy Shawn wrote in 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms-Scroll Bar function in Excel 2007 | Excel Worksheet Functions | |||
Deactivating a Forms macro button based on a worksheet condition? | Excel Discussion (Misc queries) | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
Is tabbing function available when using control forms? | Excel Worksheet Functions | |||
Forms Buttons for use with macro - recolorable? | New Users to Excel |