Is there a way to make a control tip show up via VBA?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Seth Schrock
    Recognized Expert Specialist
    • Dec 2010
    • 2965

    #16
    Just curious, is there a benefit to using a textbox in this situation compared to a label? The only property that will change is the visible property in this case.

    Comment

    • zmbd
      Recognized Expert Moderator Expert
      • Mar 2012
      • 5501

      #17
      I think it's more principle than application.
      In this case, I prefer the label as it is not intended to be a user accessible control. By default the format follows the themes (in v2007/2010) or define label style, is not part of the tab order, is not naively something a user will interact with, doesn't have any overhead for events to check, and is intended to provide information to the user (although usually of a static nature).
      Some purists will scream that a label is to never, ever be altered via code no mater what and that is what a textbox is supposed to be used for... now I've not always followed the lemmings. However, there may be some valid reason not use them... let's see what others have to say :)

      Comment

      • NeoPa
        Recognized Expert Moderator MVP
        • Oct 2006
        • 32633

        #18
        I'm with Z on this one. I can't imagine why even a purist would suggest that Labels shouldn't be used for such items. I'd suggest that they are more appropriate than TextBoxes as they are not there to interact with the user, but merely to pass information to them. A Label then (IMHO) is the more appropriate control of the two.

        Comment

        Working...