Is it possible to create a button that launches the Find box

[SimonPerry]

...instead of the user having to press the "Control Key" and "F"?? I have a lot of data in a sheet that users will need to find a particular record to then update, I wondered if it's possible to add a simple button to find a particular row to then allow updating of the data???

Thanks for your help

 

[Andrew Poulsom]

Tr assigning this to your button:

Sub Test()
    Application.Dialogs(xlDialogFormulaFind).Show
End Sub

 

[DominicB]

Good morning SimonPerry

Why do you mean by a button? You could place the ready made icon onto a toolbar. Go to Tools > Customize and under the Commands tab (Categories) go to Edit and find in the Commands list Find. Drag it onto an exisitng toolbar.

HTH

DominicB

 

[Peter_SSs]

SimonPerry

You can customise your toolbar and add a button to launch the 'Find' box. The steps are:
Tools|Customise...|Commands|Categories: Edit|Commands: scroll down to find the 'Find' command|drag the 'Find' command up to your tollbar and release|Close the 'Customise dialog

 

[SimonPerry]

Thanks for both of your suggestion however I want the button to appear on the sheet itself rather than the toolbar...

I'm going to try the other suggestion of assigning that VB to my button, is that easy to do???