How about just having your button show the Edit|Find dialog?

Option Explicit
Sub testme03()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub




japorms wrote:

Hmmm...

I think I should rephrase my request.

Can anyone help me to make a search button instead of using ctrl F.

there will be a button and a search bar. You will type in the search
term in the search box and click on the button for it to search the
sheet.

I don't know if these will be a challenge to you guys but I'm having a
hard time looking for the code for this one.

I'd appreciate any help you can give me. Cheers! :)

--
japorms
------------------------------------------------------------------------
japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
View this thread: http://www.excelforum.com/showthread...hreadid=551211

--

Dave Peterson