+ Reply to Thread
Results 1 to 8 of 8

Check box that pops a text box or message box upon selection

  1. #1
    Registered User
    Join Date
    05-06-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    10

    Check box that pops a text box or message box upon selection

    Good morning all, Im trying to create a general macro in a module form so it can be attached to a check box so it will pop a text box or message box upon hovering over or selecting that check box.

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Check box that pops a text box or message box upon selection

    like this: CheckBox.xlsm ?

    Regards
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Registered User
    Join Date
    05-06-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Check box that pops a text box or message box upon selection

    Thats a button unfortunately that wont work for my task, let me add something here to make it easier to understand. It is a check box change event that is needed or again a hovering option will work as well.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Check box that pops a text box or message box upon selection

    the check boxes are on the userform which will open by clicking the button ...

    And here is your file with the change_event implementation:Daily Service Report Final Box.xlsm
    Last edited by tehneXus; 05-06-2013 at 03:58 PM.

  5. #5
    Registered User
    Join Date
    05-06-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Check box that pops a text box or message box upon selection

    I was thinking something a bit more simple as in a simple change event. just a standard when this box changes to pop a message box that says hey tell me why than disppears not something that will stop them from working and click a seperate box. It is more for problem children not all do this just very few. so im doing this to cover myself so if they continue to fill out them incorrecly they were not only told but it is reconfirmed everytime they hover or check that box. The others who use them correctly will end up getting pissed cause if they have to do that 8 times a day 5 days a week it will start to get time consuming. Does that make more sense. They are techs they dont like anything that wastes thier time when they do things correctly. If ya know what I mean.

  6. #6
    Registered User
    Join Date
    05-06-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Check box that pops a text box or message box upon selection

    But if it was somethin like that but states again something like above, that may also work. Im just not the greatset with userform controls. I use the easier madule macros or sheet macros.

  7. #7
    Registered User
    Join Date
    05-06-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Check box that pops a text box or message box upon selection

    I found that a comment box does do what I want it to but you cannot attach it to a check box unfortunately just the cell that that check box is in. But if something could work like a comment box that would be perfect.

  8. #8
    Registered User
    Join Date
    05-06-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Check box that pops a text box or message box upon selection

    Perfect I figured out how to use those user forms and your code worked perfectly. Thank you very much for the assitance I should be good. Now to figure out how to place and equation of really difficult proportions. Will post new thread for this one. It aint an easy one thats for sure. But again thank you for the help and your time.

+ 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