Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need help with exit Macro for form fields (Word 2003)

    I'm creating a form and in one section I have several checkboxes. If the user checks any of the checkboxes, it's an indication that they need to fill out another form related to the first form. So, I would like this macro to run upon exiting the last checkbox, and would like it to check the values of all the above checkboxes to see if they are checked, and if so, display a message box. Could anyone get me started (since I'm not sure about syntax).

    Also, there's a possibility that, like so many forms in the company, people won't fill them in online and will prefer to print them and fill them in by hand. Is there a way to run a similar macro upon printing that basically reminds them that if they check those checkboxes, they will need to fill out Form 2 also?

    Thanks. - Sat.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need help with exit Macro for form fields (Word 2003)

    Why not put the reminder in the document itself? That way, the users will see it whether fill in the form online, or on paper.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need help with exit Macro for form fields (Word 2003)

    Now, Hans......you're an IT guy. You know that would be TOO easy.

    Actually, I was already going to put it in the form cause, as I said, i know that people will just print it and fill it in by hand (meh!). I just wanted to be flashy with some code (that I don't even know how to write <img src=/S/wink.gif border=0 alt=wink width=15 height=15> )

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need help with exit Macro for form fields (Word 2003)

    I don't think a macro is a very good idea. If the users don't want to tick the last check box, they don't need to click it, and then the Exit macro wouldn't be run. Making sure that the message is displayed in all circumstances where it is needed would require complicated code. It would be more effort than it's worth. Sorry.

Posting Permissions

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