accessing 'comment' feature using VBA ?

tbablue

tbablue

Active Member
Joined
Apr 29, 2007
Messages
488
Office Version
  1. 365
Platform
  1. Windows
Can anyone offer some advice on how to possibly display information via 'comments' using VBA? I'm guessing that someone may have done this before.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Sort by date Sort by votes
If you mean adding a comment try

Code: 
Range("A1").NoteText Text:="This is a comment"
 
Upvote 0
Thank You VoG. Just the start I needed; the AddComment methods looks like what I'm after.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Comment / uncomment part of the function inside LET in excel
Replies
7
Views
231
felixstraube
F
M
  • Solved
Transfer comments column from report to external sheet without macros
Replies
4
Views
318
melkontar
M
D
  • Question Question
Linking comment cells to regularly changing info
Replies
3
Views
221
Dan5977
D
M
  • Question Question
Restricting access to comments on a shared workbook
Replies
0
Views
206
mattstan2012
M
T
  • Question Question
Create and auto-populate comments
Replies
3
Views
319
rlv01
R

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

Share this page

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
Back
Top