Thread
:
Opening Built-In Date Form Dialog Box Programmatically
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson