VBA to search in comments attached to an xl cell

[red6000]

Is it possible to write VBA code that will search inside the comments
attached to a cell in excel for each sheet in the workbook.

The number and names of the sheets will constantly be changing.

Ideally what I'd like to do is something like:

1. Go to first sheet in workbook
2. for each sheet in workbook search the comments for desired info
3. On finding result return message stating the sheet name and cell that the
comment is attached to and the choice to end searching here and go to that
cell or continue searching
4. On not finding result return message with simple 'OK' button and end the
macro.

Thanks for any help/pointers in the right direction.

 

[Doug Robbins]

This group is for vba as used in Word. Suggest that you post to
microsoft.public.excel.programming.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP