Can you mouse over a cell and have it display detail that is not part of the cell entry?

Goargyle

New Member
Joined
Mar 7, 2017
Messages
4
I have a half dozen codes that a user can enter into a field. Once a code is entered into a cell (e.g. 'KM-1'), I'd like the user to be able to hover the mouse over the cell and he'd see the description of the code (e.g., 'Develop/Launch Comms Campaign'). I don't want to populate the cell with the code & full description as a default. Is there a way to set that up in Excel 2010?
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

SQUIDD

Well-known Member
Joined
Jan 2, 2009
Messages
1,692
Hi

You mean like, insert comments.
Try right clicking on the cell, insert comment.

Dave
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
To have that happen automatically, you'll need VBA:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Dim c As Range, d As Range
Set d = Intersect(Target, Range("A:A"))
If d Is Nothing Then Exit Sub
Application.EnableEvents = False
For Each c In d
    c.Comment.Delete
    Select Case UCase(c)
        Case "KM-1"
            c.AddComment "Develop/Launch Comms Campaign"
    End Select
Next
Application.EnableEvents = True
End Sub

This is set for Column A. Change as necessary. Fill in your remaining options under the Select Case, be sure and enter them in capitals.

Do you need help putting this code in?
 

Goargyle

New Member
Joined
Mar 7, 2017
Messages
4
Scott,

Thank you for the explanation and your offer of assistance. I'm not a VBA user so it's foreign to me, but I'll check it out. Right now I have an Excel spreadsheet with a column set up with a drop down where both a code and its description are displayed for the cell selection. I thought that satisfied what the user wanted. In reality, he wants to see the code displayed in the cell alone without description, but he wants the ability to hover the mouse over the cell, see the full description, and then the description disappears when he moves the mouse from the cell. Each cell in the column can have up to 6 different code/description selections, so I need to associate each code with its description and then set it up so it displays its temporary "shadow" description. I'll work with what you sent me.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,545
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows

ADVERTISEMENT

Did you try the suggestion offered by SQUIDD ??
 

Rkeev

Board Regular
Joined
Mar 11, 2014
Messages
69
Have you considered using data validation by just entering an input message and allowing any value?

RKeev
 

Goargyle

New Member
Joined
Mar 7, 2017
Messages
4

ADVERTISEMENT

SQUIDD & Michael M.,

Thanks for your suggestion. I don't believe comment entries are a solution to my challenge. For example, every time I enter 'KM-1' in a cell in the designated column, how do I always associate the comment 'Develop/Launch Comms Campaign' with it without manually doing it?
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,545
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
you said there were 6 codes / descriptions
If you list ALL 6 in a comment box the user will be able to refer to the one that relates to their input !
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
As I have said, for it to be automatic, it would require VBA. I can walk you through the steps, give me the 6 values and their corresponding description and what range the entries are being made on on the sheet and I can walk you through it.
 

Goargyle

New Member
Joined
Mar 7, 2017
Messages
4
Hi Scott,

Here's the list of values:
KM-1Develop/Launch Comms Campaign
KM-2Identify/Engage Advocacy Groups
KM-3Identify Ways to Sustain Sharing Behavior
KM-4Define/Cultivate Roles for SLT & Admins
KM-5Create Onboarding KM Training
KM-6Develop/Deploy iManage
KM-7Develop/Deploy Portal (MVPs)
KM-8Develop/Deploy TeamConnect
KM-9Implement KM Analytics
KM-10Identify/Gather Knowledge Collections
KM-11Identify/Fill Knowledge Gaps
KM-12Create Knowledge Curation Process
KM-13Develop Internal Knowledge Resources
KM-14Establish/Measure Metrics for Success
KM-15Improve Knowledge Tools Continuously
KM-16Keep KM Program Vital

<tbody>
</tbody><colgroup><col><col></colgroup>
 

Forum statistics

Threads
1,136,773
Messages
5,677,640
Members
419,707
Latest member
Anna vib

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top