Excel DataForm not picking up correct list

[Guest]

Hi again,

I've written this code, headings are in row 5 and the data below.

Sub ShowEditForm()

Range("A5:O5").Select
ActiveSheet.ShowDataForm

End Sub

But when run it keeps on picking up data from row 2. A sheet heading and
nothing else.
What am I doing wrong.

 

[Debra Dalgleish]

When you use the ShowDataForm method, Excel looks for a range named
Database, or a table that starts in the range A1:B2. The following MSKB
article has some information:


ShowDataForm Method Fails If Data Can't Be Found
http://support.microsoft.com/default.aspx?id=110462

There are naming instructions here:

http://www.contextures.com/xlNames01.html