Home

Pop Up Note

%3CLINGO-SUB%20id%3D%22lingo-sub-789001%22%20slang%3D%22en-US%22%3EPop%20Up%20Note%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789001%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20that%20has%20a%20Product%20Owner%20(Name)%20in%20column%20B%20-%20with%20project%20status%20and%20information%20that%20is%20discussed%20with%20the%20team%20in%20column%20W.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20know%20if%20there%20is%20a%20way%20that%20when%20I%20hover%20over%20the%20cell%20in%20column%20W%20that%20I%20will%20get%20a%20pop-up%20note%20displaying%20the%20name%20contained%20in%20column%20B.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20I%20can%20freeze%20panes%2C%20but%20we%20do%20a%20lot%20of%20scrolling%20both%20up%20and%20down%2C%20side%20to%20side%2C%20during%20our%20review.%26nbsp%3B%20I%20would%20just%20like%20to%20be%20able%20to%20call%20out%20the%20owners%20name%20when%20we%20co%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-789001%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789261%22%20slang%3D%22en-US%22%3ERe%3A%20Pop%20Up%20Note%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789261%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356085%22%20target%3D%22_blank%22%3E%403inproverbs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EYes%20you%20can%20display%20a%20message%20that%20pops%20up%20upon%20hovering%20over%20a%20cell%20and%20displays%20a%20value%20from%20another%20cell.%3C%2FP%3E%3CP%3EHere%20are%20the%20steps%20for%20doing%20it%3A%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1598869693%22%20id%3D%22toc-hId-1598869693%22%3E%3CSPAN%3ECreating%20a%20dynamic%20Message%20that%20grabs%20value%20from%20a%20cell%3C%2FSPAN%3E%3C%2FH3%3E%3CP%3ESay%20I%20want%20to%20create%20an%20information%20message%20in%20Cell%20A12%20that%20grabs%20the%20result%20of%20a%20payment%20function%20in%20cell%20B7.%20If%20the%20Price%20(in%20cell%20B2)%20or%20the%20down%20payment%20(in%20cell%20B3)%20change%20the%20PMT%20function%20updates%20and%20my%20information%20message%20in%20cell%20A12%20updates%20as%20well.%3C%2FP%3E%3CP%3E%3CSTRONG%3EPart%20A%3A%20Where%20to%20write%20the%20code%3F%3C%2FSTRONG%3E%3C%2FP%3E%3COL%3E%3CLI%3ERight%20Click%20on%20the%20Sheet%20Tab%20%26gt%3B%26gt%3B%20Select%20%E2%80%9CView%20Code%E2%80%99%3C%2FLI%3E%3CLI%3EAt%20the%20top%20of%20the%20visual%20Basic%20Editor%20there%20are%202%20Drop%20Lists%3B%20From%20The%20left%20one%20%26gt%3B%26gt%3B%20Select%20Worksheet%2C%20from%20the%20Right%20one%20%26gt%3B%26gt%3B%20select%20Change.%3C%2FLI%3E%3CLI%3ERemove%20the%20Selection%20Change%20Sub%20and%20keep%20the%20Worksheet_Change%20Sub%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSTRONG%3EPart%20B%3A%20Copy%20and%20Paste%20the%20code%20between%20the%202%20lines%3A%20Private%20Sub%20%26amp%3B%20End%20Sub%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EPrivate%20Sub%20Worksheet_Change(ByVal%20Target%20As%20Range)%3C%2FP%3E%3CP%3E%3CEM%3EIf%20Target.Address%20%3D%20Range(%E2%80%9CB2%E2%80%9D).Address%20Or%20Target.Address%20%3D%20Range(%E2%80%9CB3%E2%80%9D).Address%20Then%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EOn%20Error%20Resume%20Next%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EWith%20Range(%E2%80%9CA12%E2%80%9D).Validation%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E.Add%20Type%3A%3DxlValidateInputOnly%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E.InputMessage%20%3D%20Range(%E2%80%9CB7%E2%80%9D).Value%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EEnd%20With%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EEnd%20If%3C%2FEM%3E%3C%2FP%3E%3CP%3EEnd%20Sub%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20explained%20it%20in%20full%20details%20in%20Blog%20article%20on%20%22Comments%22%2C%20Here%20is%20a%20link%20for%20your%20reference%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.see-how.ca%2Fhave-fun-with-comments%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.see-how.ca%2Fhave-fun-with-comments%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20Helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
3inproverbs
Visitor

I have a spreadsheet that has a Product Owner (Name) in column B - with project status and information that is discussed with the team in column W.  

 

I would like to know if there is a way that when I hover over the cell in column W that I will get a pop-up note displaying the name contained in column B.  

 

I know I can freeze panes, but we do a lot of scrolling both up and down, side to side, during our review.  I would just like to be able to call out the owners name when we co

1 Reply

@3inproverbs 

 

Hi

Yes you can display a message that pops up upon hovering over a cell and displays a value from another cell.

Here are the steps for doing it:

Creating a dynamic Message that grabs value from a cell

Say I want to create an information message in Cell A12 that grabs the result of a payment function in cell B7. If the Price (in cell B2) or the down payment (in cell B3) change the PMT function updates and my information message in cell A12 updates as well.

Part A: Where to write the code?

  1. Right Click on the Sheet Tab >> Select “View Code’
  2. At the top of the visual Basic Editor there are 2 Drop Lists; From The left one >> Select Worksheet, from the Right one >> select Change.
  3. Remove the Selection Change Sub and keep the Worksheet_Change Sub

Part B: Copy and Paste the code between the 2 lines: Private Sub & End Sub

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range(“B2”).Address Or Target.Address = Range(“B3”).Address Then

On Error Resume Next

With Range(“A12”).Validation

.Add Type:=xlValidateInputOnly

.InputMessage = Range(“B7”).Value

End With

End If

End Sub

 

 

I explained it in full details in Blog article on "Comments", Here is a link for your reference

https://www.see-how.ca/have-fun-with-comments/

 

Hope that Helps

Nabil Mourad

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies