Thread: moving mouse over a cell to show hid a shape

Hello aryanarch,

Welcome to the Forum!

I think the easiest solution is to use a regular comment. You can then change the comment's size, color, text, etc using VBA. When the mouse moves over the cell with the shape will be displayed.

Add a comment to cell "A1". Add the macro below to the same sheet and run it. The macro will change into a right triangle.

Sub CommentTest()

  Dim Cmt As Comment
  
    Set Cmt = Range("A1").Comment
    
      With Cmt
        .Shape.AutoShapeType = msoShapeRightTriangle
        .Shape.TextFrame.AutoSize = True
      End With
  
End Sub

Hello ,

Add this macro to the worksheet the rectangle shape is on. The macro allows only cells in column "A" to be displayed. You can change this if you need to. Change the name of the rectangle (Rectangle 1) to the name of your shape. Here is the macro code.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

  If Not Intersect(Target, Range("A:A")) Is Nothing Then
    ActiveSheet.Shapes("Rectangle 1").TextFrame.Characters.Text = Target.Text
  End If
  
End Sub

How to Save a Worksheet Event Macro

1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S