Sorting after ShowDataForm

[Rob]

Excel 2000

Is it possible after running ActiveSheet.ShowDataForm (to add a new record)
to sort the records in the database?

I've tried to include the code to sort but it seems that ShowDataForm once
running doesn't return to the next line of code, nor does it work if I use
Call to run a sub.

Can get over the issue by running sort as separate macro but would be nice
to include in a single operation i.e. add new records then sort.

Thanks, Rob

 

[Tom Ogilvy]

No, you can't get inside the Dataform functionality with the built in
dataform. At least in xl97, entering data with the data form does not fire
the change event.

 

[Rob]

Tom,

Thanks for the reply, guess I'll be using two macros.

Regards, Rob