What does "me" do in VBA

[Hlatigo]

I have the following code that is activated when a command button is clicked. I am not too sure what is being accomlished here. Maybe because I thought that me was used for the current form, but the current form does not have anything in the text boxes when it appears. Can anyone help? thanks so very much!!!



Private Sub cmdUpdateValue_Click()
Dim fmodal As New frmParameter


strCurrentfile = Me.txtCurrentLink.Text
strNewfile = Me.txtNewLink.Text
strLinkedDir = Me.txtLinkedDir.Text
strCurrentDIR = Me.txtCurrentDIR.Text
strNewDIR = Me.txtNewDIR.Text

fmodal.Show vbModal

End Sub

 

[Andrew Poulsom]

Me does indeed refer to the object containing the code. It's not necessary.

Maybe you have your assignment expressions the wrong way round, eg:

txtCurrentLink.Text = strCurrentfile

 

[Hlatigo]

There are a few text boxes embedded within the excel sheet itself and i believe all it is doing is allowing the user to mannually update or change the folder date that the file is located in but I am not to sure. This isn't mine, I was just asked to update it with a additional process.