View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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