I am looping down a column and getting the activecell value to do some validation on entered fields. The field is a text field but entering a number value is not necessarily an error. If validation fails, I am trying to write a log message using "text" + Activecell + "text" to identify the contents of the cell that are not valid. But if someone enters a numeric value that isn't valid, I get a type mismatch error. If I change it to "text + str(Activecell) + "text" then I get an error when the validation fails for a text entry. Any recommendations on how to write that log message without first doing an IF statement to find out if the value is text or numeric? I tried forcing the column cell properties to be text but still got the same error. Line 12 is where the error occurs.

1 aocheck = 0
2 For x = 1 To lcnt
3 If ActiveCell.Value = lse(x) Then
4 aocheck = 1
5 Exit For
6 End If
7 Next
8 If aocheck = 0 Then
9 erec = erec + 1
10 errorstr(erec, 1) = "Load Assets"
11 errorstr(erec, 2) = "Cell" + " " + ActiveCell.Address
12 errorstr(erec, 3) = "Asset Owner " + Str(ActiveCell) + " not identified as Load Asset Owner in Participant Tab"
13 End If