Dataforms

[Peter J Aldersley]

I am unable to get a dataform to work within a macro without an error being
generated. Is this a problem in Excel or is it not possible to use dataforms
within macros?

 

[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