Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to select one by one picture on my sheet with VBA?
Hi!
How can i select one by one picture on my sheet through VBA "for each pic in Activesheet.pictures...? and how do i have to define(dim) my picture, dim pic as??? please help. thanks! Marko Svaco |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to select one by one picture on my sheet with VBA?
Hello Marko, A Picture belongs to the Shapes class of the Worksheet it is on. Dim Pic As Shape For Each Pic In Activesheet.Shapes If Pic.Type = msoPicture Then Pic.Select End If Next Pic Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=513885 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to select one by one picture on my sheet with VBA?
dim pic as picture
should work ok, too. If you use the object browser (F2 in the VBE), you can show hidden elements and still see the picture object. marko wrote: Hi! How can i select one by one picture on my sheet through VBA "for each pic in Activesheet.pictures...? and how do i have to define(dim) my picture, dim pic as??? please help. thanks! Marko Svaco -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to select one by one picture on my sheet with VBA?
Thanks a million!!!
it works perfectly!!!! Marko Svaco |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to select one by one picture on my sheet with VBA?
Thanks!
Marko Svaco |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
How do a lock a picture to the rest of the spread sheet row entry | Excel Worksheet Functions | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
How can I make a picture of my Excel sheet? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |