View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Concatenating strings into a variable

Gary,

Thanks but maybe I didn't explain myself clearly in my original post

If I have a variable named "ABCD"

Dim ABCD as Boolean
ABCD = True

What I want to do is take two strings "AB" & "CD" and say
If "AB & "CD" = True then..........

How do I tell VBA to look at that "ABCD" as a variable named "ABCD"
and not just a string?


You can't!
ABCD is the defined variable and so must be used as dimensioned!

You can't assemble a string to replace it because that string occupies
a different space in memory than that which was reserved when you
dimensioned the variable.

What I see here is a basic lack of understanding programming basics.
Perhaps you'll be better helped if you explain the concept of what
you're trying to do so we can example how to code for that!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion