How to check what the first 10 letters of a string are

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I am using vartext and split to read in one line at a time the data
from a text box.

I would like to know how to check if vartext(1) starts with the phrase
"Company in"

Thank you,

Gary.
 
I'm assuming 'vartext' is an array? If so ...

If Left$(vartext(1), 10) = "Company in" Then

See 'Left Function' in the help file for details.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to run code on whole table and not just record displayed on form ? 7
Code not working - please help =) 1
evaluate a variable to see if it is 'empty' or if it contains just 'spaces'... 7
Test the length of a field 1
VBA Multiple Line handling with Split() 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
What comes after Windows 10? 15
Word Removing unwanted "lines" within a MS Word 10 table 1

Back
Top