Hello,
I have this userform that I’m using to update company information. i have a button in the spreadsheet that opens up a userfom with the name of the company in C5 cell. any idea why i get this error?
In the userfom Initialize i have this code:
Private Sub UserForm_Initialize() currentrow = Application.WorksheetFunction.Match(Sheets(“Sheet1”).Cells(5, 3), Range(“VendorList”)) txtvendor.Text = ws.Cells(currentrow, 1).Text txtcontact.Text = ws.Cells(currentrow, 5).Text txtphone.Text = ws.Cells(currentrow, 6).Text txtemail.Text = ws.Cells(currentrow, 7).Text txtfax.Text = ws.Cells(currentrow, 8).Text End Sub