Opening Built-In Date Form Dialog Box Programmatically

N

nkjsterk

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
 
D

Dave Peterson

The line of code could be as simple as:

ActiveSheet.ShowDataForm

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening Built-In Dialog Box Programmatically 2
Opening Built-In Custom AutoFilter Dialog Box Programmatically 3
Macro to launch the Activate dialog box? 2
Getting a file name using a built in dialog box 1
Macro to Force Response in Dialog Box 1
replacing built in keyboard shortcuts with my macros? 2
unwanted dialog box appears when opening a form 1
How Do I Supress Update Dialog Box Programmatically 6

Top