Search results

  1. M

    Setting ControlSource in VBA

    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...
Back
Top Bottom