Visual Basic Text Functions

[Moiz]

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

 

[Frank Kabel]

Hi
variable=len(variable_2)
also use Mid without application.worksheetfunction

 

[Auric__]

I need to manipulate text variables using Visual Basic programming

what is thestatement for:

Len - length of variable

x = Len(y$) 'x is a numeric variable

Mid

x$ = Mid(y$, start, length) 'start and length are both integers

I tried:

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

That's because they're not worksheet functions.

 

[Moiz]

Thank you

it is working now.

Moiz