LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default changing pictures according to cell value


hi guys

I've a sheet with vba code and many pictures the code's function is to
display the picture which i write its name in cell (A1)
it works well
the problem that the code stop to work after adding number of pictures
that makes me conclude that excel has limit number of picture or
pictures size or there is aproblem
so i hope to find any one who can expaline this form me or solve the
problem


Code:
--------------------
Option Explicit

Private Sub Worksheet_Calculate()
Dim sora As Picture
Me.Pictures.Visible = False
With Range("d8")
For Each sora In Me.Pictures
If sora.Name = .Text Then
sora.Visible = True
sora.Top = .Top
sora.Left = .Left
Exit For
End If
Next sora
End With
End Sub
--------------------


i hope to know the reason of the error


--
frsm
------------------------------------------------------------------------
frsm's Profile: http://www.excelforum.com/member.php...o&userid=31231
View this thread: http://www.excelforum.com/showthread...hreadid=557600

 
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
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
changing a cell to changing the link Jared Excel Worksheet Functions 7 May 8th 06 08:41 AM
Changing cell colour depending on another cells value... Web master Excel Discussion (Misc queries) 3 January 10th 06 12:30 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Changing Cell formats to date fields automatically PCLIVE Excel Worksheet Functions 3 April 12th 05 10:34 PM


All times are GMT +1. The time now is 06:15 AM.

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

About Us

"It's about Microsoft Excel"