difference between ! and . character in the syntax of the VBA identifieer "Form" and "me" RRS feed

  • Question

  • Hi there,
    Greetings from Shank. Am new to the forum.

    I am in the process of developing a VBA app. The thing is I don't know the difference between the following vb statements. They all behave the same way (i.e copy  the contents the Left Text Box to the Right one. Can you tell me what the "!" exclamation mark does when compared to "." dot character. Can I use them Interchangeably.
    Private Sub CommandButton1_Click()
    Me.TextBox2 = Me.TextBox1
    Me!TextBox4 = Me!TextBox3
    form.TextBox6 = form.TextBox5
    form!TextBox8 = form!TextBox7

    End Sub
    Sub displayform()
    Dim frm As New UserForm1
    Unload frm
    Set frm = Nothing
    End Sub
    Monday, September 28, 2020 9:19 AM

All replies