View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yogesh Gupta Yogesh Gupta is offline
external usenet poster
 
Posts: 8
Default How to get Find dialogbox through VBA macro in Excel2007

I am using Excel2007

I am looking for a VBA code to show excel find dialogbox that you get
through Ctrl+F.

I am not able to get the same dailogbox through excel VBA macro.

dialog box through following code is not similar to what you get with Ctrl+F

Application.Dialogs(xlDialogFormulaFind).Show

Another one which gives this dailog box does not work with auto open macro
Application.CommandBars.FindControl(ID:=1849).Exec ute


--
Yogesh Gupta