Character Locations in Strings
 

Is there a way to access individual characters within strings? In C++, you
can use brackets, but I don't know how to do it in VBA.

i.e. word = "string" -- to access the 3rd charcter, I would use word[3]
(or something like that) in C++. For VBA....?

Thanks.
Pflugs

Character Locations in Strings
 

mid("string",3,1)

--
Tim Williams
Palo Alto, CA


"Pflugs" wrote in message ...
Is there a way to access individual characters within strings? In C++, you
can use brackets, but I don't know how to do it in VBA.

i.e. word = "string" -- to access the 3rd charcter, I would use word[3]
(or something like that) in C++. For VBA....?

Thanks.
Pflugs

Character Locations in Strings
 

Thanks!

"Tim Williams" wrote:

mid("string",3,1)

--
Tim Williams
Palo Alto, CA


"Pflugs" wrote in message ...
Is there a way to access individual characters within strings? In C++, you
can use brackets, but I don't know how to do it in VBA.

i.e. word = "string" -- to access the 3rd charcter, I would use word[3]
(or something like that) in C++. For VBA....?

Thanks.
Pflugs