Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am trying to move a shape that is selected to the left. Have the below code: Sub Test() Dim oSheet as workhseet Dim oShape as Shape Dim oObj as Object ' I don't know if the shape or something else is selected, so I get the object selected. set oSheet = Application.ActiveSheet oObj = Application.Selection if TypetName(oObj) = "Picture" then ' Shape selected set oShape = oObj ' Try to convert to oShape to access its properties. I get an error type mismatch here oShape.left = oShape.left - 60 end if End Sub Thank you, Carlos Lozano |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Manually changing a picture (shape) name property | Excel Discussion (Misc queries) | |||
Connect a number to a picture bank and import that picture to exce | Excel Discussion (Misc queries) | |||
Picture displayed when item selected in a different cell | Excel Discussion (Misc queries) | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) |