tool bars

[RobcPettit]

Hi, Ive created a command bar and added a button using ,Set Cbct1 =
cbar.Controls.Add(Type:=msoControlButton)'. All works fine. Id like to
add a textbox and cant find any info to do this. I can add a drop down
box ok, and list box. Any ideas how to add a textbox and even a label.
Regards Robert

 

[ShaneDevenshire]

Hi,

Here is a list of the mso control types I found:

msoControlActiveX
msoControlAutoCompleteCombo
msoControlButton
msoControlButtonDropdown
msoControlButtonPopup
msoControlComboBox
msoControlCustom
msoControlDropdown
msoControlEdit
msoControlExpandingGrid
msoControlGauge
msoControlGenericDropdown
msoControlGraphicCombo
msoControlGraphicDropdown
msoControlGraphicPopup
msoControlGrid
msoControlLabel
msoControlLabelEx
msoControlOCXDropdown
msoControlPane
msoControlPopup
msoControlSpinner
msoControlSplitButtonMRUPopup
msoControlSplitButtonPopup
msoControlSplitDropdown
msoControlSplitExpandingGrid
msoControlWorkPane

I would suggest msoControlEdit but I haven't tested.


If this helps, please click the Yes button.

 

[RobcPettit]

Thanks for your reply. The edit control worked perfect. The
commandButton suggest is great. Obvious when its suggested.
Regards Robert