Extract comments (Not notes) from excel

IamLost

New Member
Joined
Jan 8, 2013
Messages
16
Hello, I have looked through the search and cant find anything, also google is not helping. I have inherited an excel spreadsheet which has a lot of data as well as a lot of comments. I am looking for a way to extract the comment into a new cell. Everything I read online refers to the "old" comments which are now called Notes I believe.

To simplify, I have a spreadsheet with for e.g. Column A has information in the cell as well as a comment. What I want to be able to do is run a macro to extract or copy the information in the comment and paste this in the cell to the right.

Any help would be much appreciated.
 

IamLost

New Member
Joined
Jan 8, 2013
Messages
16
When you put the code in a standard module, what is the error message that you get?
I get this error message and in debugger the second screenshot
1607956015836.png

1607956054871.png
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Zot

Well-known Member
Joined
Nov 26, 2020
Messages
964
Office Version
  1. 2016
Platform
  1. Windows
Hello, Thank you for that, I had a read through and tried the code but it doesnt work. When i delete the comment and try a note, it does provide a popup with the text. But nothing happens when I have a comment. Not sure if its my terminology I have wrong or not?
Guess I'm outdated and old 😄

What was previously called Comment is now called Note. It is an annotation. Thanks for question anyway. I get updated now
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,301
Office Version
  1. 365
Platform
  1. Windows
@My Aswer Is This
On newer versions of Excel the comments you are talking about are now called notes.
 

IamLost

New Member
Joined
Jan 8, 2013
Messages
16

ADVERTISEMENT

You subject Title says:

You subject Title says: Extract comments (Not notes) from excel
My script looks for comments not notes.
My understanding was Comments are the new style where you can reply etc and Notes are the older style yellow background. Apologies if I have this the wrong way around.

i am using a fairly new version of excel
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,301
Office Version
  1. 365
Platform
  1. Windows
@IamLost
I have no idea why you get that error & cannot replicate it.
If there were no comments on the active sheet, then nothing should happen.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,301
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

He asked about comments not notes.
Exactly, the OP is talking about the new style comments, not the old style ones.
 

IamLost

New Member
Joined
Jan 8, 2013
Messages
16
@IamLost
I have no idea why you get that error & cannot replicate it.
If there were no comments on the active sheet, then nothing should happen.
Hmm I will try closing down excel and opening / saving a brand new version of excel. Thank you again for trying it is genuinely appreciated. When you try the code does it work on your version? Just so I can make it as a solution or not.
 

IamLost

New Member
Joined
Jan 8, 2013
Messages
16
Guess I'm outdated and old 😄

What was previously called Comment is now called Note. It is an annotation. Thanks for question anyway. I get updated now
Every day is a school day. haha. Thank you again for trying
 

Watch MrExcel Video

Forum statistics

Threads
1,127,107
Messages
5,622,777
Members
415,927
Latest member
vedasinternational

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top