Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
Changing cell colour depending on another cells value... | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Changing Cell formats to date fields automatically | Excel Worksheet Functions |