ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   putting often-used combinations of controls in a class (https://www.excelbanter.com/excel-programming/378670-re-putting-often-used-combinations-controls-class.html)

NickHK

putting often-used combinations of controls in a class
 
Arne,
You are talking about creating Custom Controls. For that you need an
environment that you can compile into an .OCX ; not something you can do in
Excel VBA.
VB5/6 did have a Learning Edition that was free, although I don't know if it
supported this.
There was also a discounted version called something like "Control Creation
Edition" which would be suitable.
As VB has been discontinued, MS are no longer selling it, although you can
get copies from eBay and the likes. If you decide to purchase, make sure you
get the full CD (with Help and license), not just someone dodgy copy.

NickHK

"Arne" wrote in message
...
Is it possible to make a class for combinations of userform controls. I

have
a few combinations of such controls that interact in a certain way.

Consider,
just as an example, the combination of a text box and a spin button. It is
easy enough to put those two controls in a class, but is it possible to
construct an object that can be put on a userform, ant that can be used in
the same way as a normal control?

Thanks in advance.





All times are GMT +1. The time now is 12:45 PM.

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