I'd like to use the Worksheet's "Data / Form ..." functionality in a macro. I know the command for that is
Sheets.ShowDataForm
but I also recognize that this is based on the first data table found in the form, starting from A1.
Is there a way around this? I have more than one table on a worksheet, and I'd like to use some code that could recognize where the ActiveCell is (for example) and use THAT form. (This works fine, manually, on the WorkSheet, but in code the command always reverts to the first table it finds, from Cell A1.)
I'm using Excel '97 (still).
Thanks,
Chris