is this left() VBA or Worksheet function

[lezawang]

Hi
I am reading about dealing with text in VBA (the link below) and I see code similar to the one below. My question, this left() function is VBA native or Worksheet function. My guess is VBA native. Thanks a lot.

Sub myleft()
    Dim x As String
    Dim y As String
    x = InputBox("enter phone number")
    y = Left(x, 3)
    MsgBox "your area code is  " & y
End Sub

https://www.excel-easy.com/vba/string-manipulation.html

 

[MARK858]

It is VBA else it would be WorksheetFunction.Left although I can't think of any difference between the 2 bar a miniscule speed difference.

 

[jolivanes]

What happens if you put your code from Post #1 in a module, highlight the word "Left" and push your F1 key?
If it is a WorksheetFunction, it will say so in the pop-up screen.

 

[lezawang]

Thank you all. The F1 trick is amazing. Thanks all once again

 

[Rick Rothstein]

What happens if you put your code from Post #1 in a module, highlight the word "Left" and push your F1 key?

You do not have to put the keyword in a module... this will work the same if you put the keyword in the Immediate Window as well. Also, it is not necessary to highlight the entire word... just clicking in the word or immediately next to the word would be sufficient.

 

[Rick Rothstein]

You do not have to put the keyword in a module... this will work the same if you put the keyword in the Immediate Window as well. Also, it is not necessary to highlight the entire word... just clicking in the word or immediately next to the word would be sufficient... and then press the F1 key.

I forgot to include the red highlighted text in my original post.

 

[jolivanes]

Hi Rick.
Thanks for the clarification.
There are a lot of roads that lead to Rome but the most important thing is to get there and quite often it does not really matter how while at other times it does.