I'm trying to set the ControlSource of a TextBox in VBA.
Normally this is simple:
Me.TextBox.ControlSource = "=Date()"
But...
I need to use the DateAdd function:
Me.TextBox.ControlSource = "=DateAdd('w';1;Date())"
This gives an error: 'the syntax of the expression you gave is invalid'
the...