Finding and Coloring with InputBox Object

An Excel file that teaches how to perform Finding and Coloring with InputBox Object operation.

Excel Powered Finding and Coloring with Inputbox Object

The search value is obtained from the user via an InputBox. The range scan is performed using a loop. Matching cells are highlighted in color. The search is case-insensitive. The number of results is displayed in the message box.

Hope it is useful.