Set value of Text Input Box but allow overwrite Follow
I'd like to set the value of a Text Input Box so that value automatically shows in the box when the when the user clicks print or print preview. The user needs to be able to overwrite that value if necessary. I tinkered with Autocomplete but that doesn't seem to do what I had hoped. The Text Input Box in question will store a 4 digit year 3 years from the current year. I used the following while tinkering with Autocomplete and the script runs properly:
Value = Right("0" & Year(DateAdd("yyyy", 3, Date)),4)
Is there any way to have this value appear in the Text Input Box by default but allow the user to overwrite?
Thank you in advance,
Please sign in to leave a comment.