Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make same picture appear more than once
Hi I have the macro working for inserting different pictures but what if I
want to see the same picture output more than once without changing the picture name. In another worksheet, I have the a list with the name and picure number. When the name matches the corresponding picture, it will show but for example, if there were three of the same name only one picture will show and the other two will be blank. Below is the code I'm using. Private Sub Worksheet_DD() Dim oPic As Picture Me.Pictures.Visible = False With Range("B16") For Each oPic In Me.Pictures If oPic.Name = .Text Then oPic.Visible = True oPic.Top = .Top oPic.Left = .Left Exit For End If Next oPic End With With Range("B22") For Each oPic In Me.Pictures If oPic.Name = .Text Then oPic.Visible = True oPic.Top = .Top oPic.Left = .Left Exit For End If Next oPic End With and continues with more coding Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make a picture a chart | Charts and Charting in Excel | |||
How do I take a picture and make it a graph in Excel? | Charts and Charting in Excel | |||
Can I make my Hyperlink a picture? | Excel Discussion (Misc queries) | |||
how to make a picture pop-up when selecting a cell? | New Users to Excel | |||
How can I make a picture of my Excel sheet? | Excel Worksheet Functions |