Question

commandbutton和togglebutton的区别是什么?

在EXcel-VBA里,请问commandbutton和togglebutton的区别是什么啊?怎么感觉有点不一样啊

Answer 1

表4-5 VBA里的ActiveX控件和Visual Basic 2005里对应的Windows Forms控件ActiveX控件（VBA）Windows Forms控件（Visual Basic 2005控件）TextBoxTextBoxLabelLabelComboBoxComboBoxListBoxListBoxCheckBoxCheckBoxOptionButtonRadioButtonToggleButton不适用（可以使用CheckBox控件，并把它的Appearance属性设为Button）CommandButtonButtonTabStripTabControlMultiPageTabControlScrollBarVScrollBar、HScrollBarSpinButtonNumericUpDownImageControl不适用（可以使用PictureBox控件代替）表4-6显示了表4-5里列出的许多控件都有的属性、方法和事件在名字上的改变。表4-6 Windows Forms控件常见成员的改变成员VBAVisual Basic 2005属性CaptionText属性ContainerParent属性HeightHeight、Size属性HWndHandle属性MousePointerCursor属性ParentFindForm方法属性PictureImage属性SelLengthSelectionLength属性SelStartSelectionStart属性SelTextSelectedText属性ToolTipTextToolTip组件属性WidthWidth、Size方法MoveSetBounds方法SetFocusFocus方法ZOrderBringToFront、SendToBack事件DblClickDoubleClick事件GotFocusEnter事件LostFocusLeave事件ValidateValidating除了属性、方法和事件的不同，每个控件特有的成员也有所不同。表4-7列出了这些不同之处。表4-7 比较ActiveX控件和Windows Forms控件之间的成员控件VBAVisual Basic 2005TextBoxAlignmentTextAlignTextBoxLockedReadOnlyTextBoxChangeTextChangedLabelAlignmentTextAlignLabelBackStyle把BackColor设为透明LabelWordWrap（自动）ComboBoxListItemsComboBoxListCountCountComboBoxListIndexSelectedIndexComboBoxLockedDropDownStyle = DropDownListComboBoxStyleDropdownStyleComboBoxAddItemAdd、AddRange、InsertComboBoxRemoveItemItems.RemoveComboBoxChangeTextChangedComboBoxClickSelectedIndexChangedListBoxColumnsMultiColumn、ColumnWidthListBoxListItemsListBoxListColumnCountListBoxListIndexSelectedIndexListBoxMultiSelectSelectionModeListBoxSelCountCountListBoxSelectedGetSelected、SetSelectedListBoxAddItemAdd、AddRange、InsertListBoxRemoveItemRemoveListBoxItemCheck不适用（仅对CheckedListBox适用）CheckBoxAlignmentCheckAlignCheckBoxStyleAppearanceCheckBoxValueCheckStateCheckBoxClickCheckStateChangedOptionButtonAlignmentTextAlignOptionButtonAppearanceFlatStyleOptionButtonValueCheckedOptionButtonClickCheckedChangedFrameAppearanceFlatStyle（GroupBox）FrameClickClick（Panel）CommandButtonCancel不适用（使用Form的CancelButton代替）CommandButtonDefault不适用（使用Form的AcceptButton代替）CommandButtonValue不适用ScrollBarMaxMaximumScrollBarMinMinimumScrollBarTabIndexTabIndexChangedScrollBarTabStopTabStopChangedScrollBarValueValueChanged