Find, but not Replace

[ExcelMan]

I have an app where I attach the built-in Find/Replace dialog box to a
command button. Is there a way to disable the Replace Tab, or better yet,
remove it altogether?

Thanks.

 

[Guest]

hi,
no. not possible. you might be better off replacing the
build in find box with vb code

code for find
Cells.Find(What:=Inputbox"Find WHAAAAT,?!?!?",
After:=ActiveCell, Lookin:=xlFormulas,_
LookAt:=xlPart, SearchOrder:=xlByRows,
searchDirection:=xlnext,_
MatchCase:=False).Activate