LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DD DD is offline
external usenet poster
 
Posts: 68
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make a picture a chart Bucs fan Charts and Charting in Excel 2 October 20th 07 11:34 AM
How do I take a picture and make it a graph in Excel? DavidBr318 Charts and Charting in Excel 1 April 6th 06 05:45 AM
Can I make my Hyperlink a picture? Rachel Excel Discussion (Misc queries) 1 January 17th 06 06:23 PM
how to make a picture pop-up when selecting a cell? tendercare New Users to Excel 1 September 6th 05 12:47 PM
How can I make a picture of my Excel sheet? Hebel Excel Worksheet Functions 3 December 5th 04 09:40 PM


All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"