In EXCEL 2003 version, there are two toolbars "Form" and "Control Toolbox" under "View-Toolbar" ( while in 2007 version, " Development Tools-Insert " is called form control and ACTIVEX control ), You can add controls to the worksheet. Although ACTIVEX controls have powerful properties and strong controllability, they cannot be associated with cells, so they are used in forms. One main difference is that form controls can be associated with cells, and operation controls can modify cells Value (without programming), so it is used in worksheets. I think that most of the functions of the two controls are the same. There are a lot of explanations about the two online, and I was a little dizzy. Instead, the ActiveX controls are used in the form ), and they can only be used by setting the control format or specifying a macro The ActiveX control can be used not only in the worksheet, but also in the user form, and has many properties and events, providing more ways to use it. Form controls can only be added and used in the worksheet (haha, they are called form controls, but they are not used in the form. Two types of controls can be inserted when in use, one is form controls (also called form controls in earlier versions, English Form Controls), and the other is ActiveX controls.
0 Comments
Leave a Reply. |