LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default a comment box that only displays when the cell is actually selected

I have an Excel 2002 worksheet that I created a few years ago, and I can't
remember how I got a certain cells to do what it's doing.

Whenever you select that cell, a box appears just below that cell that looks
like a comment box, but without the connecting arrow. But unlike a comment
box, this one doesn't appear when you hover the cursor above the cell. It
only appears when you select the cell; and it remains visible as long as the
selection cursor remains in the cell, regardless of where you move the
cursor.

I dont' think it's any kind of a comment box, because when you right-click
on the cell, you can still select "Insert Comment" and create a separate
comment box, so that when you hover the cursor over the cell, the new
Comment box is visible, and when you click on the cell to make it the
current selection, the other mystery box appears.

Like a regular comment box, this one has a light yellow background, and you
can format the text you write in it, because I notice that I was able to set
some of the characters to a bold font. I just can't figure out how I
created that type of box. I would like to reproduce this so I can use this
type of box as an alternative to the regular comment boxes in some of my
worksheets.

How do you create these boxes that look like comment boxes, but without the
connecting arrow and that only display when you actually select the cell?

Thanks in advance,

Paul


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserted comment not displays in the cell it displays on top row S.Kumar Excel Worksheet Functions 1 September 22nd 09 07:32 PM
Center Comment Over Selected Cell inthepickle Excel Programming 3 December 27th 06 03:58 PM
Comment Displays date aposatsk Excel Discussion (Misc queries) 8 August 4th 06 12:44 PM
displaying a comment only when the cell is selected Jeff Excel Discussion (Misc queries) 2 July 6th 05 09:21 AM
displaying a comment only when the cell is selected Jeff Excel Discussion (Misc queries) 1 July 6th 05 08:18 AM


All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"