ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Auto insert a comment box. (https://www.excelbanter.com/excel-worksheet-functions/220738-auto-insert-comment-box.html)

Chiefgarcia

Auto insert a comment box.
 
I am trying to find a way where I can have excel Insert a comment box
automatically.

For example:
I have a data sheet and every time I need to insert a new row, I then need
to insert a comment box in every cell. Instead of copying and pasting, is
there a way to make excel auto populate the comment box when I insert a new
column?

If so, how or is there a macro that I can use?

Thanks.

[email protected]

Auto insert a comment box.
 
do you want the comment ballon to pop up ever time you
select any cell in col.

"Chiefgarcia" wrote:

I am trying to find a way where I can have excel Insert a comment box
automatically.

For example:
I have a data sheet and every time I need to insert a new row, I then need
to insert a comment box in every cell. Instead of copying and pasting, is
there a way to make excel auto populate the comment box when I insert a new
column?

If so, how or is there a macro that I can use?

Thanks.



All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com