If, however, I need a combobox to display a certain font, I have no choice but to use an ActiveX control. Forms controls are lean and mean and simple to use.
Weighing the good and the bad, I always use Forms controls unless I have a specific reason to use an ActiveX. ActiveX controls carry a lot more overhead with them and have a history of being buggy. The ActiveX combobox, for instance, has fifteen events.Īll that flexibility comes at a cost (you knew it would). ActiveX controls, on the other hand, have a lot of events. Also, Forrms controls have one basic event, the click event, which you access by assigning a macro to the control. Viewing the properties of an ActiveX control demonstrates how much more you can do with them than with Forms controls. ActiveX controls give the spreadsheet designer a lot more flexibility when it comes to displaying or reacting to events of controls. The primary differences, for me anyway, are events and formatting. Obviously, a decision to use one or the other will based on their differences, not their similarities. Checkboxes of either type are used to select or deselect an option. That’s fundamentally the same as the ActiveX textbox. That is, a textbox from the Drawing toolbar is a control in which you can type text. In general, the two types of controls are similar in that they work the same way. I don’t know, but I’ll tell you how I decide.
Activex for mac excel how to#
Kevin, like others before him, asks how to decide which ones to use. There are two kinds of controls that you can put on a worksheet, ActiveX controls from the Control Toolbox and Forms controls from the Forms (or Drawing) toolbar.
0 kommentar(er)
