ExcelBanter - search button on sheet (ctrl+f)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - search button on sheet (ctrl+f) (https://www.excelbanter.com/excel-programming/407564-search-button-sheet-ctrl-f.html)

pswanie

search button on sheet (ctrl+f)

im trying to get a macro for the "edit" "find" (ctrl+f)

im gona put it in a form button

Dave Peterson

search button on sheet (ctrl+f)

You just want to display that edit|Find dialog?

Application.Dialogs(xlDialogFormulaFind).Show

pswanie wrote:

im trying to get a macro for the "edit" "find" (ctrl+f)

im gona put it in a form button

--

Dave Peterson

Jim Thomlinson

search button on sheet (ctrl+f)

Something like this...

Sub ShowFindDialog()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub
--
HTH...

Jim Thomlinson

"pswanie" wrote:

im trying to get a macro for the "edit" "find" (ctrl+f)

im gona put it in a form button

All times are GMT +1. The time now is 07:10 AM.