Results 1 to 3 of 3
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    MenuItem Statusbar Text (97/Others?)

    When you create a menuitem in VB, you can specify a text to be added into the statusbar property.

    According to this MS article
    <hr>specifies help text to be displayed in the status bar when the menu item is selected or browsed by the user<hr>

    But if you (in XL97, at least) use this property, it doesn't seem to do anything. For example"
    <pre>Sub StatusBarText()
    Dim myNewMenu As Menu
    Dim myNewMenuItem As MenuItem

    Set myNewMenu = Application.MenuBars(xlWorksheet).Menus.Add("Test" )
    Set myNewMenuItem = myNewMenu.MenuItems.Add("Test Statusbar")
    With myNewMenuItem
    .OnAction = "TestMe"
    .StatusBar = "What does this do?"
    End With
    End Sub</pre>


    If you look at the objects in the locals window or use the immediate window, the property is the text, but the text nevers seems to be displayed in the statusbar. AM I missing something obvious? When is the text displayed? Or what is the property for?

    Steve

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

    Re: MenuItem Statusbar Text (97/Others?)

    In some versions up to and including Office 95, Microsoft used status bar help texts for built-in menu and toolbar items, and made it possible for programmers to add them to custom items too. For some reason not known to me, Microsoft decided to remove this feature from Office 97 and higher. I think that they left the property in the Office 97 object model for compatibility reasons, so that old code wouldn't bomb. The property is not present any more, or at least not exposed, in Office XP.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: MenuItem Statusbar Text (97/Others?)

    Thanks, I was beginning to suspect that though I could not find anything that stated this.

    Steve

Posting Permissions

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