Opening Built-In Date Form Dialog Box Programmatically
 

Hello,

I would like to know if it possible to open the dialog box belonging to

the Data - Form... menu through some VBA code. I prefer this rather
than
reinventing the wheel, building a dialog box on my own and performing
the sort operation through a recorded macro in VBA.


So its is only about opening the dialog box.


Can anybody help me?


Thanks in advance,


Nico Sterk

Opening Built-In Date Form Dialog Box Programmatically
 

The line of code could be as simple as:

ActiveSheet.ShowDataForm

Lots of times just recording a macro will lead to a solution.

wrote:

Hello,

I would like to know if it possible to open the dialog box belonging to

the Data - Form... menu through some VBA code. I prefer this rather
than
reinventing the wheel, building a dialog box on my own and performing
the sort operation through a recorded macro in VBA.

So its is only about opening the dialog box.

Can anybody help me?

Thanks in advance,

Nico Sterk

--

Dave Peterson