LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Hover Messages

MS Excel 2003, Workbook name 2008 Results.

In worksheet named Inventory, Column M has alpha-numeric codes - the
worksheet contains 8000+ rows.

In worksheet named Function Codes, 365 a-n codes are held in column B,
with their corresponding text descriptions in column C.

What is needed: when the user hovers the cursor over a cell in Inventory
column M, Excel finds the a-n code in worksheet Function Codes column B,
and displays the corresponding text from column C the same way as in a
hyperlink Screen Tip.

Finally, the user must be able to click on a column M cell, make an a-n code
change, and the new text description appear when hovering over the changed
cell (after the correction has been entered).

What would the macro code be and where would it be placed?

 
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
hover over text greg Excel Programming 3 March 28th 08 08:33 PM
Hover-over Function Raul Excel Programming 3 January 3rd 08 09:04 PM
a button that will hover Ben Excel Programming 3 July 13th 06 05:09 PM
Hover change Voodoodan Excel Discussion (Misc queries) 4 May 5th 06 01:32 PM
Hover over variable? HotRod Excel Programming 2 May 5th 05 09:18 PM


All times are GMT +1. The time now is 04:20 AM.

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"