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

[Goargyle]

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?

 

[SQUIDD]

Hi

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

Dave

 

[Scott Huish]

To have that happen automatically, you'll need VBA:

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]

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]

Did you try the suggestion offered by SQUIDD ??

 

[Rkeev]

Have you considered using data validation by just entering an input message and allowing any value?

RKeev

 

[Goargyle]

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]

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]

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]

Hi Scott,

Here's the list of values:

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

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