ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA & XL2K: Working with objects/class modules (https://www.excelbanter.com/excel-programming/315403-vba-xl2k-working-objects-class-modules.html)

Mike Mertes

VBA & XL2K: Working with objects/class modules
 
For fun and for practice I wrote a class that handles Excel's shapes and
their properties. (I even used some trig functions to animate them... it's
cute.) Each instance of my class draws a shape on Sheet1 that represents it.
This is all just fine and dandy, but it occurred to me that I don't know how
to *name* classes programmatically as they are instantiated. If I could, the
user could create any number of shapes on the screen without typing a line
of code. How is this possible?

TIA!
-Mike




All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com