I need to manipulate text variables using Visual Basic programming

what is thestatement for:

Len - length of variable
Mid

I tried:

variable = Application.WorksheetFunction.Len (Variable)
but it does not work.

Moiz