Hi Max

Try the below..(Sheet event)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Application.Intersect(Target, Range("A1:B2")) Is Nothing Then
ActiveSheet.Shapes("txt1").Visible = True
Else
ActiveSheet.Shapes("txt1").Visible = False
End If

End Sub


--
Jacob


"Max" wrote:

How can the sub below be modified to a sheet level code that works like the
pop-up DV input message (ie when DV cell is selected, the input message will
show)? Or any other sub which can give the same functionality - when cell
(within a defined range on the sheet) is selected, show the shape "txt1",
when cell is deselected, hide the shape? Thanks

Sub T_Box1()
If ActiveSheet.Shapes("txt1").Visible = False Then
ActiveSheet.Shapes("txt1").Visible = True
Else
ActiveSheet.Shapes("txt1").Visible = False
End If
End Sub