News, tips, advice, support for Windows, Office, PCs & more
Home icon Home icon Home icon Email icon RSS icon

We're community supported and proud of it!

  • Dates and calculations

    Home Forums AskWoody support Microsoft Office by version Dates and calculations

    Viewing 1 reply thread
    • Author
      • #1948507
        AskWoody Lounger

        I have a form with a filed named “Date”. When someone enters the date I would like a macro to determine if that date is after August 1, 2019. If it is, then a bookmark called “Hello” becomes visible. IF the date is August 1, 2019, or before, then that bookmark remains invisible.

        I also have a field called “Type”. It is a drop-down field with 5 choices “1,2,3,4,5”. On opening the file, or after saving the file , the field randomly becomes 1,2,3 or 4. However, I still want to be able to choose 1,2,3,4 or 5 manually at any time.

        Reply With Quote
      • #1949183
        AskWoody MVP

        Windows 10 Pro version 21H1 build 19043.1052 + Microsoft 365 (group ASAP)

        1 user thanked author for this post.
    Viewing 1 reply thread

    Please follow the -Lounge Rules- no personal attacks, no swearing, no politics or religion.

    Reply To: Dates and calculations

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.