I think you may be mixing the rows for columns, or perhaps I'm still not
visualizing your set up. You say you have 14 rows (cells)... do you mean you
have data in 14 columns per row? Is so, which columns are these (it's just
as easy to give you a solution for your exact setup as it is to give you a
general solution that you have to change later). And when you insert a row,
you want to insert Comments in the 14 cells in that row, correct? You showed
the information that you want to put in the Comments... where is that
information currently located at?

--
Rick (MVP - Excel)


"Chiefgarcia" wrote in message
...
Thank you for your willingness to help me on this.
To make it more specific, I hava a data that sheet that contains about 14
rows (cells). But I want to find a way to insert comment boxes
automatically.
So when I right clicka and choose the insert button, the new row show all
the
new 14 (cells) with a comment box on them and if possible to have the
following information in the comment box:

Phone:
Website:
Org Description:
Leads/Contacts:
Active Members at Nike:
Other Notes:

Thanks.

"Rick Rothstein" wrote:

Yes, this can be done. What do you mean when you say "in every cell"? Do
you
mean every cell in the new row (all 256 of them for XL2003 and lower,
16384
of them for XL2007)? Or do you mean a smaller range within the row? If
the
smaller range, tell us what that range is. The bigger question is... what
do
you want in each of these Comment boxes?

--
Rick (MVP - Excel)


"Chiefgarcia" wrote in message
...
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.