Searching within comments added to excel cells

  reddwarfcrew 22:50 21 Jul 05
Locked

Is it possible to write VBA code for XL97 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.

  VoG II 22:56 21 Jul 05

click here should get you started.

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Why ecommerce hasn't taken off on social media

New MacBook Pro 2016 review | MacBook Pro with Touch Bar review: Apple's expensive and powerful…