Call Data->Form excel menu from code 1

[mveera]

Hi,

I would know how to call the Data->form menu from my code. To call the Sort Dialog i use Application.dialogs.(). Is there any way i can write code to call the Data->Form menu automatically.

Thanks
Veera

 

[RobBroekhuis]

Try the following:

application.CommandBars(1).Controls("Data&quot.controls("Form...&quot.execute

I got it to work this way (you have to select a valid range first).
Rob

 

[mveera]

Thanks.

That worked.

Thank You
Veera