ShowDataForm method

I have a simple sheet with cells A6 to N6 defined as headers. These cells are uniformly formated as text with cell borders. All cells below this are for data entry. When I select the first data entry cell (A7) and use the standard Excel menu options Data/Forms, the form appears and works fine. When I try to create a Macro using the same sequence, the macro is created as:

Please Login or Register  to view this content.

This does not work and generates the following error:

Run-Time error '1004':
ShowDataForm method of worksheet class failed

Can this method be used in a Macro

Are you actually calling the code from the data sheet? If not try using the correct sheet, you don't need to select anything.

Please Login or Register  to view this content.

Note: according to the Forum Rules you must wrap code in Code Tags

MyData was just a dummy name to demonstrate. If your code is failing then presumable your activecell is not within the data table. Try adding some code to activate a cell within the table

Presumably you have some data in the table already.

Please Login or Register  to view this content.

naming a table of data as "database" helps Excel recognise it as a database, as does making the Header row bold. It isn't strictly necessary and the Database Form should appear once you have two or three lines of daat in the table. What you mustn't have is blank Rows and/or Columns