Thelingly95
New Member
- Joined
- Nov 1, 2024
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
How would you create a pop out box when you click on a cell? It would contain all of the information in the cell, but would display it in a larger box.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Selection
If .Count = 1 Then
If Not IsEmpty(.Value) Then MsgBox .Value
End If
End With
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Selection
If .Count = 1 And .Column = 5 Then
If Not IsEmpty(.Value) Then MsgBox .Value
End If
End With
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Selection
If .Count = 1 Then
If Len(.Value) > 50 Then MsgBox .Value
End If
End With
End Sub
It helped. Many thanks, all!One way would be to use a comment....so, click on the cell in question....go to the Insert Tab, then select the Comment item. slope game
Fill in the required data in the text window.
Then next time you click on that cell the comment window will open.