I'm no coder by a long shot. I found some VBA code on the net years ago, changed it to fit my needs for my MS 2010 Excel spreadsheet.
I just recently upgraded to Office 2016 and all of a sudden I'm getting "Compile Errors." "Can't find project or library". This is the code snippet that is failing.
and it is failing on the "TRIM" statement.
If Trim(Me.applicantname.Value) = "" Then
Me.applicantname.SetFocus
MsgBox "Please enter a customer name"
Exit Sub
End If
If someone could help me out with this it would be greatly appreciated. Because I'm totally clueless.
Thanks,
I just recently upgraded to Office 2016 and all of a sudden I'm getting "Compile Errors." "Can't find project or library". This is the code snippet that is failing.
and it is failing on the "TRIM" statement.
If Trim(Me.applicantname.Value) = "" Then
Me.applicantname.SetFocus
MsgBox "Please enter a customer name"
Exit Sub
End If
If someone could help me out with this it would be greatly appreciated. Because I'm totally clueless.
Thanks,