Dates, Forms, Calculations etc.

macropod · #3 09-17-2019, 04:23 PM

Quote:

Originally Posted by ElfegoBaca

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.

Assuming you're working with formfields, see: https://www.msofficeforums.com/word/...-tutorial.html

Quote:

Originally Posted by ElfegoBaca

I also have a field called "Type". It is a drop-down field with 4 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 5 manually at any time.

How can you have "a drop-down field with 4 choices "1,2,3,4,5""? You've specified 5 choices. Whichever option you choose will remain chosen if you save the file that way, but all 5 options will still be available for selection next time the file is opened.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to filter between two dates in MS Query criteria when the dates are text ("20180903", etc.)	kingmb	Excel	2	09-11-2018 01:08 AM
X axis graph all dates when date column contains specific dates..possible ?	DBenz	Excel	2	03-28-2018 04:59 AM
Autofill dates - how can I get the same date and consecutive dates?	Exhale	Excel	3	04-05-2016 03:11 AM
Calculations	etobias	Word	4	12-03-2015 01:36 PM
Changing Actual Finish dates changes original Finish dates	SomewhereinTX	Project	3	12-20-2013 10:25 AM