Search in Column with Inputbox

Date 04 March 2017
Author exceldepo
Category Macros
Type XLSM

An Excel file that teaches how to perform Search in Column with Inputbox operation.

Excel Source: Search in Column with Inputbox

The InputBox value is stripped of spaces. Matching cells are found using the Find method. Results are highlighted and centered on the screen. Repeated searches are performed using a loop. Errors are safely caught and reported.

Hope it is useful.

ADVERTISEMENT AREA

Related Files