properties window for active x controls vs form controls in vba

[lezawang]

Hi
I inserted form controls buttons and active x control buttons. In vba window when i click anywhere on the sheet, i see Properties-sheet1 window, and when i click on any Active X control button, a properties window for that object appears. But when I click on any Form control buttons, no properties window will show up? Why is that?

Also when I click on any Form control button and then after that click on any Control X button, excel will not show the properties window of that Active X anymore. Is like I lost them after clicking on Form control button. Why is that?

Thank you so much.

 

[mikerickson]

Form controls don't have properties, per se.
What are you trying to do with the buttons?
To change the caption you would use this.

With ActiveSheet.Shapes("Button 1")
    .TextFrame.Characters.Text = "cat"
End With

 

[lezawang]

Thank you. No not to change anything. Just trying to experiment things for learning purpose. Thank you.

 

[mikerickson]

Forms controls are essentially fancy shapes. To alter there appearance, you treat them as shapes. To access their values (e.g checked,unchecked for check boxes) you use the Shapes .ControlFormat property.
Note forms menu control ListBoxes and ComboBoxes have 1-based lists (rather than 0-based for ActiveX). The values for Forms menu checkboxes are xlOn and xlOff, not True/False.