Command Button

[RBritt]

I have placed a command button on my worksheet. When I click the
button, I want to launch the Ctrl + F (Find) function. Does anyone
have an idea as to how I can do this? Thank you!



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------

 

[Jean-Paul Viel]

Hi,

Create a macro like this:



Sub MacroFind()



Application.Dialogs(xlDialogFormulaFind).Show



End Sub



And assign it to your button.

 

[RBritt]

That worked JP. Thank you very very much!!!



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------