LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 90
Default Shortcut key for displaying the active cell comment

I want to simplify the data entry in a spreadsheet. Currently the user
has to refer to an 11 x 14 sheet with tables front and back to
determine what value to enter in a cell. I have used the copy picture
function to create a series of tables in Excel and place them into cell
comments in the appropriate cells. In an efffort to speed up data entry
even more, I was wonderfing if there was a shortcut key to show, then
hide again, the comment so the user would not have to reach to the
mouse and place it on the current cell in order to see the comment.
Since the sheet is full of comments, only the current cell should be
affected. Is there a shortcut key to accomplish this by showing/hiding
the current comment, or do I need a macro to toggle the current comment
on and off? And if so,how?

Thanks, and thanks to all who share their time and expertise to help
others. Your efforts add so much to the value of Excel!

Tonso

 
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
linking to a cell within a text cell or comment BlueJ2005 Excel Worksheet Functions 0 May 11th 06 10:36 PM
displaying a comment only when the cell is selected Jeff Excel Discussion (Misc queries) 1 July 6th 05 08:18 AM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Cell comment boxes shouldn't change size/shape unless changed by u sam Excel Discussion (Misc queries) 1 March 3rd 05 05:23 PM
Highlight Active Cell...With a Diffrence Peter Excel Discussion (Misc queries) 1 January 31st 05 01:18 PM


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

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

About Us

"It's about Microsoft Excel"