Results 1 to 6 of 6
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    toolbar and statusbar (2000)

    Stupid qstn...
    But is possible to insert in userform of Excel VBA a statusbar and toolbar, similar form in vb 6.0?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: toolbar and statusbar (2000)

    You can select Tools | More Controls... (while the userform is open in the Visual Basic Editor).
    Tick the check boxes for Microsoft StatusBar Control 6.0 (SP6) and Microsoft ToolBar Control 6.0 (SP6).
    Then click OK.
    There will be two new buttons on the Control Toolbox.
    Use these to add a status bar and toolbar to your userform.
    Position them where you want them.
    Select (Custom) in the list of properties and click the ... button to set the specific properties of these controls. This works as in VB6.

    Warning: since these controls are not native Forms controls in Office, they may not work on all PCs.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: toolbar and statusbar (2000)

    GODD EXPLAIN!!!!!
    Tks.

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: toolbar and statusbar (2000)

    on fly Hans....
    But wat is difference from a standard form and mdi form?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: toolbar and statusbar (2000)

    That is a VB6 question, not a VBA question.

    An application such as Notepad or Microsoft Paint is a "single document interface" (SDI) application - you can open only one file in Notepad (although you can open several instances of Notepad).

    An application such as Microsoft Photo Editor is a "multiple document interface" (MDI) application - you can open several files within the Photo Editor application, each with its own window within the application window. You can arrange these windows side by side, or tile them, etc.

    See image below.

    Note: recent versions of Excel and Word can behave both as SDI and as MDI applications, depending on the setting of the "Show windows in TaskBar" option.
    Attached Images Attached Images

  6. #6
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: toolbar and statusbar (2000)

    Hans sorry for:"That is a VB6 question, not a VBA question."...
    When you explain is all very simple!
    Tks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •