Excel VBA Code developed in VBA 7.0.1627 is failing in VBA 7.0.1628 RRS feed

  • Question

  • I have a textbox embedded in my worksheet which is as follows :

    Following is my vba code  :

    Private Sub Workbook_Open()

    Sheet1.Something.Text = "Do Something"

    End Sub

    This text box is updated on opening my Excel workbook and also afterwards using the same mechanism (Sheet1.something).

    All this has been working for the past 4 months, suddenly my VBA version has changed from VBA 7.0.1627 to VBA 7.0.1628 and I am getting a compile error.

    The compile error is for sheet1.something.Text. It says member not found as shown above.

    Please help me solve this problem. It would also be really helpful , if anyone could direct me to the release notes or version updates from VBA 7.0.1627 to version 7.0.1628.

    • Edited by ArMD Thursday, February 5, 2015 5:05 AM
    Thursday, February 5, 2015 5:04 AM


All replies