Home > Excel Tutorial > Excel : Search Entire Workbook

Excel : Search Entire Workbook

With Vba ,it is possible to search an entire workbook, for a searched value.

We will use The Find Method for this process.In Excel Program, The Find & FindNext Method is a very powerful option in finding data  and is useful.

When the macro runs , inputbox opens and asks the data we want to find. The found results are listed on the MsgBox  with cell addresses. The process continues until user  stops it.

 

Example File Can Be Downloaded Here

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: