ButtonBar extra control in form - How to use it? RRS feed

  • Question

  • Hello,

    I was wondering if I can get some information about the ButtonBar control for Excel Form.

    To get access to it, you go to VBA(Alt+F11) - Forms - Toolbox - Controls you can right click - Additional Controls and add:

    ButtonBar Class

    I have found 0 information on how to use the control, how to add buttons, how to add actions for each button, change labels and so on.

    Can anyone help me with documentation on this controll?

    Kind regards,


    Friday, March 17, 2017 12:57 PM

All replies

  • D,
    re:  buttonbar

    The buttonbar may be a toolbar that older versions of Windows (not Office) used.

    The Toolbox in the VisualBasic Editor for Office  has a "Command Button" icon on it.
    Clicking that icon enables you to "draw" that button on to a user form.  Try it.

    This may help...

    Jim Cone
    Portland, Oregon USA (Dropbox)
    (free & commercial excel add-ins & workbooks)
    Friday, March 17, 2017 2:30 PM