![]() If you don't know VBA, you may have a much harder time working with them, as you need to write code to do things with them.īy contrast, Forms controls are much more simple. They also have a variety of built in macro events that are linked specifically to the objects. ![]() ActiveX controls, available from the Control Toolbox, and Forms controls.ĪctiveX controls are pretty robust, allowing you to change many of their properties, such as their backgrounds. I'm not going to post that project right now, but I may in future.Īt any rate, the question sort of stuck with me, so I thought I'd write something up on it. Eventually, I'd like to write up a formal article on this for my site, but for start, I thought I'd blog it to get some of my thoughts on virtual paper. □Įxcel has two sets of controls available to put on a worksheet. That project was actually a Net Present Value calculation to evaluate whether it would be better to purchase a software update plan, or replace my software at full retail every 3 years. I don't use them a lot, but they can be quite handy, and ironically I'd just finished using them in a project of mine. ![]() I got an email the other day from a friend wondering if I had anything to explain how to use Form controls.
0 Comments
Leave a Reply. |