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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picture scroll with active cell
I have not worked with picture objects, but have you tried using the TopLeft
property? It might do what you want. Check it out in VBA help. "John" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picture scroll with active cell
Hi JLGWhiz
Thanks for your help, i tried it out but can't get it to work. I don't know anough about VBA. Regards John "JLGWhiz" wrote in message ... I have not worked with picture objects, but have you tried using the TopLeft property? It might do what you want. Check it out in VBA help. "John" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picture scroll with active cell
Hi Everyone
Does anyone have any ideas, anything I could try. Plus does anyone know how many Pictures can be used, It seem to stop at 62. Regards John "John" wrote in message ... 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 |
Reply |
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) |