Using Left in VBA

[michaeltsmith93]

Hi,

I'd like to change the following code such that only the Left three characters of the Department value are taken. Left tutorials aren't helping me much.

With ws


    .Cells(ERow, 1).Value = Me.ptmember.Value
    .Cells(ERow, 2).Value = Me.StudyRole.Value
    .Cells(ERow, 4).Value = Me.MatrixRole.Value
    .Cells(ERow, 5).Value = [COLOR=#ff0000]Me.Department.Value[/COLOR]
    
End With

 

[MARK858]

What issues are you having, it should be the same syntax as the worksheet function...

.Cells(ERow, 5).Value = Left(Me.Department.Value, 3)

 

[Waimea]

Hi, I could be wrong but maybe

Left(Me.Department.Value;3)

 

[michaeltsmith93]

Mark858, that makes perfect sense. Another tutorial had the Value function outside and Left afterward, and that confused me. Thank you both.

 

[Norie]

Try this.

    .Cells(ERow, 5).Value = Left(Me.Department.Value, 3)