+ Reply to Thread
Results 1 to 6 of 6

Tool Tip in text box that disappears when clicked?

  1. #1
    Registered User
    Join Date
    01-08-2013
    Location
    ottawa,ontario
    MS-Off Ver
    Excel 2003
    Posts
    6

    Tool Tip in text box that disappears when clicked?

    Hello, I have user form that has multiple text boxes and I would like to have a tooltip in the textbox that is always visible but disappears once the user activates the box. I currently use the 'Value' field in the text box properties but then the user has to delete the text prior to entry. Is there a way to do this?

    Regards'
    Jon

  2. #2
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: Tool Tip in text box that disappears when clicked?

    Hi .. There are several ways to accomplish this, but you could use the TextBox1_Enter()

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-08-2013
    Location
    ottawa,ontario
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Tool Tip in text box that disappears when clicked?

    I tried your suggesting but it adds the "text" when I click in the box. I need the text to appear when the form is opened and dissappear when the textbox is clicked.

    Regrds'
    Jon

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Tool Tip in text box that disappears when clicked?

    Jon

    What exactly do you want?

    A tooltip? Or text actually in the textbox that will disappear as soon as it's entered, and perhaps re-appear on leaving if nothing is entered?
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    01-08-2013
    Location
    ottawa,ontario
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Tool Tip in text box that disappears when clicked?

    The text to actually be in the text box that will disappear as soon as data is entered. I have the tool tips already but most people don't read them

    Thanks'

  6. #6
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: Tool Tip in text box that disappears when clicked?

    You could use an IF statement based on what you are putting in for your tooltip....

    Please Login or Register  to view this content.

+ 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