]
On Behalf Of Adrian
Sent: Wednesday, July 22, 2009 8:39 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Problem with duplicating a Shape and defining
OnAction property
Instead of trying to fix this problem, could anyone tell me how I
could make multiple images execute the same code but
Well, in this case, the shape object in question is not merely a shape,
instead an OLE Object (Image Control) is contained in it. The OLE Object
(Forms Image Control) exposes its own events. One way (weird one) is to
duplicate the Image1 shape on Click and in the Click Event handler
programmatica
By VBS, i believe you are asking for Visual basic in excel (and not
vbscript) I have listed couple of links below. I hope this helps
http://www.your-save-time-and-improve-quality-technologies-online-resource.com/free-vba-tutorials.html
http://www.businessbookmall.com/Microsoft_Excel_Directio
Hello NandKumar
Please scan through the recent posts and files on this group. You would find
links and reference to books for learning VBA.
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 10:26 AM, Nandkumar
Hello Bro/Sis
Pls How to learn Vbs Macros pls send me link how to learn
Thanks My Big B/S
Nandkumar
On Wed, Jul 22, 2009 at 10:16 AM, vivek agrawal
wrote:
> Hello,
> According to me, the error is because of the mismatch of object type and
> not that you are not able to assign onaction property
Hello,
According to me, the error is because of the mismatch of object type and not
that you are not able to assign onaction property to a shape object.
The new_shape is of "Excel.*Shape*" type where as you are assigning to the
new_shape - the duplicate of an Excel.*Shapes *type. While, SHAPE obje
Instead of trying to fix this problem, could anyone tell me how I
could make multiple images execute the same code but with a different
parameter upon clicking?
--~--~-~--~~~---~--~~
--
