Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picture scroll with active cell
Hi Everyone
I've taken John McGimpsey's code and modified then for my needs. What I'm trying to do is, have the picture follow along with the active cell. I 've got a list of names from B3:B62 and D3:D62 that matches a picture. Now the picture are staying at the top, and would like them to scroll down with the selection. Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim oPic As Picture Me.Pictures.Visible = False For Each oPic In Me.Pictures If oPic.Name = ActiveCell.Text Then oPic.Visible = True " This line not working " oPic.Top = ActiveCell.Offset(3, 3) oPic.Left = 600 Exit For End If Next oPic End Sub Hope someone can help me Regards John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display picture according to active cell | Excel Programming | |||
Active Cell will not scroll to next cell | Excel Discussion (Misc queries) | |||
Screen does not scroll as active cell moves down the page | Excel Discussion (Misc queries) | |||
Picture in Cell of Active Sheet | Excel Programming | |||
Cursor keys move active cell or scroll screen, how do I select whi | Excel Discussion (Misc queries) |