Comment in specific place

  • Thread starter Thread starter Esradekan
  • Start date Start date
E

Esradekan

I wish to insert comments for particular cells, but wasnt the comment
to appear in a specific location, not the default location. How can I
do that?

TIA
Esra
 
I wish to insert comments for particular cells, but wasnt the comment
to appear in a specific location, not the default location.  How can I
do that?

TIA
Esra
Click to expand...

Oh, using Excel 2007.

Thanks
Esra
 
As far as I know, there is no way to position a comment.
You can change the size using VBA code.

You may want to consider using Data Validation...
with Settings to allow any value
with Input Message check marked and your text entered
with Error Alert not check marked.
You can position the displayed message manually and it looks like a comment.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html (editorial review )

..
..
..

"Esradekan" <[email protected]>
wrote in message
I wish to insert comments for particular cells, but wasnt the comment
to appear in a specific location, not the default location. How can I
do that?

TIA
Esra
Click to expand...

Oh, using Excel 2007.
Thanks
Esra
 
As far as I know, there is no way to position a comment.
You can change the size using VBA code.

You may want to consider using Data Validation...
   with Settings to allow any value
   with Input Message check marked and your text entered
    with Error Alert not check marked.
You can position the displayed message manually and it looks like a comment.
--
Jim Cone
Portland, Oregon  USAhttp://www.contextures.com/excel-sort-addin.html(editorial review )

.
.
.

"Esradekan" <[email protected]>
wrote in message


Oh, using Excel 2007.
ThanksEsra
Click to expand...

OK, thanks for the info. Appreciate the help.

Esra
 
Back
Top