Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Create a method in your class called (eg) "Clear" which clears the cell and deletes the picture.
After calling that just set the class instance to Nothing. Or put some code in the class_terminate event, which should get called when you set an instance to Nothing (but I'm not absolutely sure about scope etc in this case, so you should test that thoroughly) -- Tim Williams Palo Alto, CA wrote in message oups.com... I have a class that I made, called clsPicCell. Each clsPicCell object has a two objects within it, a range object and a picture object (both private objects). I would like help on how to be able to delete a clsPicCell object, call it xCell. The desired result is that if I code something like: xCell.delete it will clear the range object and delete the picture, and get rid of the object all together. How would I do this? I was unable to find any related topics, so point me in the direction of one if you know of it. Thanks, -Abe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cant delete user defined default chart type | Charts and Charting in Excel | |||
How do I delete a User defined default excel chart | Charts and Charting in Excel | |||
Delete user-defined charts | Charts and Charting in Excel | |||
User-defined type collection in class module | Excel Programming | |||
Create my own Class Object for Ranges, having trouble assigning name property | Excel Programming |