I am attempting to move code to a database from my userform and all of my data is transferring perfect including this one, however, I just added the limitation of only moving the first 5 characters and apparently I didn't do it correctly as I am getting an error. Could someone help me understand where I want the 'Left(Cell.value, 5)' coding to make this work? I thought I had it right but apparently not. Thank you for any help someone can give.
Sheets("Travel Expense Codes").Range("DataStartCodes").Offset(CodesTargetRow, 11).value = Left(Cell.value, 5) = cmbOtherExpenseCode
Sheets("Travel Expense Codes").Range("DataStartCodes").Offset(CodesTargetRow, 11).value = Left(Cell.value, 5) = cmbOtherExpenseCode