none
VBA is causing me new headaches RRS feed

  • Question

  • Hi all,

    I recently upgraded to windows 10 from 8.1

    All my VBA codes were working and life was good. But I now have a problem. 

    The following code:

    Private Sub TextBox1_Change()
    TextBox1 = Format(TextBox1, "000")
    End Sub

    Used to come up without an error on a form in an excel spread sheet. Now, since my upgrade, it comes up with "Compile Error, Wrong number of arguments or invalid property assignment".

    Anyone got any ideas? It's driving me nuts!

    Thursday, June 9, 2016 1:32 PM