+ Reply to Thread
Results 1 to 2 of 2

Revealing UserForm Control Values with MouseOver

  1. #1
    Registered User
    Join Date
    01-20-2004
    Location
    Western NY
    Posts
    99

    Revealing UserForm Control Values with MouseOver

    I have a UserForm with a half dozen Controls created "on the fly", i.e., via VBA code. Is there any way to "reveal" something about a given control by simply placing the mouse on the control.

    As an example, consider a UserForm with 4 text boxes. The original userform is modified during application execution to add the 4 textboxes. I want the boxes to be quite small; too small to show the value of the textbox normally. I would like the value of the TextBox to be revealed when the mouse is moved over the textbox.

    I have tried using the "click" procedures but those procedures do not seem to work for controls created with VBA.

    Any help would be appreciated.

  2. #2
    Registered User
    Join Date
    01-20-2004
    Location
    Western NY
    Posts
    99
    Well, I found an answer to this question. Each userform control has a property called "ControlTipText". If the value of this property is non-blank, that value is revealed when the cursor is positioned over that control.

    This works with controls and ControlTipText properties built in the VBA editor or programatically.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1