+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2003
    Posts
    104

    Field Codes - Prompt for Yes/No answer

    Hi, I am trying to learn more about field codes so I can interact with the end user and ouptut text paragraphs with variables based on their input.

    In my document I have given them the option of selecting a customer type.

    Based on the customer type I would like to ask a further question or give an additional drop down form with additional text fields to input.

    I've tried including dropdown fields and text fields in the sections where it says {IF {Customer_Type} = "TRUE" "DROPDOWN, TEXT ETC." "FALSE"} but the forms can't be selected by the user.

    So.. if its not possible to include form fields in the field codes is it possible to popup a selection on screen and store the Yes/No response in a variable?

    Hope that makes sense!!

  2. #2
    Registered User
    Join Date
    12-14-2007
    Location
    Ontario
    Posts
    19

    Re: Field Codes - Prompt for Yes/No answer

    In VBA a Messagebox with yes or no is handled in this way

    Code:
    Select Case MsgBox("This is your message the user will see", vbYesNo)
            Case vbNo
                'enter code to take place on No event
            Case vbYes
                 'Enter your code to take place on Yes event
            End Select
    Hope that gets you on the right path.

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.2.0