Opening Built-In Dialog Box Programmatically
 

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

Opening Built-In Dialog Box Programmatically
 

Hi Nico,

Try:

Application.Dialogs(xlDialogSort).Show

---
Regards,
Norman



wrote in message
oups.com...
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

Opening Built-In Dialog Box Programmatically
 

That's the one I needed!

Thanks, Nico Sterk