Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Seeking a tweak to the sub below. Currently it displays "txt1" aligned with
the top edge of the selected cell, just to the right of it. Unfortunately this position obscures immediate cols to the right of the selected cell, which user occasionally needs to see. I want to "push" the display vertically down a bit and align the top edge of "txt1" just below the bottom edge of the selected cell so that user can see the contents in the adjacent cells. Thanks ---------- Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Application.Intersect(Target, Range("A31:A200")) 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically change autoshape color to that of another autoshape | Excel Programming | |||
Display autoshape with circumstances | Excel Programming | |||
Code Tweak | Excel Programming | |||
Display AutoShape in UserForm | Excel Programming | |||
macro in vba to display autoshape | Excel Programming |