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 2
Built-in Dialog box for folders? 4
File Properties in Word Open File Dialog Box 0
Macro to launch the Activate dialog box? 2
Find/Replace built-in dialog in XP 2
Enable Macros Dialog Box 3
display built-in dialog box using VBA 0

Top