Marco/VBA Code to Serach a Column

[robertguy]

Hi,

can anyone help me with a Macro/VBA code which I can run via a butto
which displays a Search Box that will only search in a specific colum
e.g. Column B


Many thanks for any help


Regards



Ro

 

[AlfD]

Hi!

The ordinary Find/Replace box (ctrl/F) will do this.

Select your column (the whole column) by clicking on, say, the B at th
top.
Call up Find. Choose Search By Columns.

If you need something more sophisticated, there's always VBA...

Al

 

[Frank Kabel]

Hi
try something like
Sub foo()
Columns("B:B").Select
Application.Dialogs(xlDialogFormulaReplace).Show
End Sub