Active x/userform/ or normal worksheet controls

[Eisasuarez]

Hi,

i have seen many times people always ask when referring to controls, is it a form, normal or active x control?

now my question is which one is easier to use?
are the coding side to reference these controls different and do you reference the different type of controls?

why is this question always asked as im presuming there must be a major difference in referencing different controls?

if someone can give a list n code examples that would be really appreciated

 

[Eisasuarez]

Any info luck anyone

thank you

 

[RoryA]

The question is asked because the controls work differently. Forms controls for instance have limited formatting options and you assign macros to them; ActiveX controls have more options and more events that you can work with, but they are also generally not as stable on worksheets.

There are different ways to refer to the controls in code. For example:

Forms checkbox:

        Dim cb As Excel.CheckBox
    Set cb = ActiveSheet.CheckBoxes("Check Box 1")
    MsgBox cb.Value
    
    Dim cf As ControlFormat
    Set cf = ActiveSheet.Shapes("Check Box 1").ControlFormat
    MsgBox cf.Value

ActiveX checkbox:

    Dim cb As MSForms.CheckBox
    Set cb = ActiveSheet.CheckBox1
    MsgBox cb.Value
    
    Set cb = ActiveSheet.OLEObjects("CheckBox1").Object
    MsgBox cb.Value