Find, but not Replace

  • Thread starter Thread starter ExcelMan
  • Start date Start date
E

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.
 
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
 
Back
Top