+ Reply to Thread
Results 1 to 6 of 6

Help Box in Userform Testing

  1. #1
    Forum Contributor
    Join Date
    02-04-2014
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    136

    Help Box in Userform Testing

    Good morning all,

    I am trying to see if it is possible to create a populating help box on a userform.

    Attached is a mock up file to test it on, what I am looking at accomplishing is when a user has selected a textbox or other - (either by clicking or tabbing), when the focus is on that box a help prompt is filled out in the large "TextBox4".
    I have created a "Help" Tab reference and column "B" is the wording I am wanting to appear.

    Simply:

    When a user has selected the TextBox1 (Next to "A") = in "TextBox4" appears the wording "Need to enter a time. Eg. "12:00""

    The trick is to show when the focus is on the Textboxes or others...
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,468

    Re: Help Box in Userform Testing

    This article will accomplish precisely what you are seeking. Let me know if you have any problems implementing it.

    ARTICLE LINK <-------

  3. #3
    Forum Contributor
    Join Date
    02-04-2014
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Help Box in Userform Testing

    That is awesome, thank you

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,468

    Re: Help Box in Userform Testing

    Your welcome. Thanks for the Add Rep.

  5. #5
    Forum Contributor
    Join Date
    02-04-2014
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Help Box in Userform Testing

    Hopefully I can adapt some of it to Excel.....

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,468

    Re: Help Box in Userform Testing

    Well ... its all VBA for Applications. Hopefully there wont be any editing.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Testing userform is complete
    By OnlySteveH in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2012, 08:26 AM
  2. [SOLVED] Testing to see if Userform is loaded
    By k06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2012, 01:45 PM
  3. Excel Crashes when testing userform
    By Magnet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2012, 08:54 AM

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