Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show shape on cell select, Hide shape when cell is deselected
OK Max. Try out the below
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Application.Intersect(Target, Range("A1:H10")) Is Nothing Then Me.Shapes("txt1").Left = Target.Left + Target.Width Me.Shapes("txt1").Top = Target.Top ActiveSheet.Shapes("txt1").Visible = True Else ActiveSheet.Shapes("txt1").Visible = False End If End Sub -- Jacob "Max" wrote: Thanks, Jacob. I need the shape display to sort-of follow/float next to the cell selected (just like the DV's input message) as the defined range is a long col eg A20:A200, and the shape won't be visible once I select cells further down in that range |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Move shape, object, pic to center of new cell based on cell value | Excel Programming | |||
Show & Hide Shape in a Sheet | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |