Opening Built-In Dialog Box Programmatically

[nkjsterk]

Hello,

I would like to know if it possible to open the dialog box belonging to
the Data -> Sort 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

 

[Norman Jones]

Hi Nico,

Try:

Application.Dialogs(xlDialogSort).Show

 

[nkjsterk]

That's the one I needed!

Thanks, Nico Sterk