Logical String Evaluation

[Tom Ogilvy]

An example of one

is:

"Month=4"

Again, that isn't the question you asked.

 

[Guest]

Bob,

I did get a little of track there, sorry, wasn't sure why we were building
strings and concatenating, etc...

Looks like the Select Case procedure you posted does just fine.

Regards,
NPO

 

[Guest]

This is reminiscent of yesterday when (in the VB6 forum) somebody said, "only
REAL programmers use zero-based arrays." Like we're not programmers if we
choose to start counting at one.

I assumed mNum is passed to the Sub as a String, in which case, parse it the
way most experienced VB[A] developers would.

Oooh!

 

[Guest]

Well, that's going to be tricky if you coerce a range to an array, and it
doesn't make one fake!

And, it was qualified with the word 'most'. So, please don't be too quick to
put words in my mouth.

And, I was on the wrong track, which didn't help much, there's nothing to
parse.

Regards,
NPO

This is reminiscent of yesterday when (in the VB6 forum) somebody said, "only
REAL programmers use zero-based arrays." Like we're not programmers if we
choose to start counting at one.

I assumed mNum is passed to the Sub as a String, in which case, parse it the
way most experienced VB[A] developers would.

Oooh!

 

[Guest]

Hello!! I wasn't talking about YOU, I was talking about somebody else.

 

[Bob Phillips]

What me? I didn't say '...the way most experienced VB[A] developers would'

 

[Bob Phillips]

Nate,

Yeah shame it derailed a little, as I thought that your point on time and
performance was a good, valid point. I confused it a little by re-iterating
what I had said to the OP earlier, that as far as I could see, all he wanted
was
If Month = 4 Then
without using Month as a variable name of course .

That will teach me to try and make two points at once . No harm done
though.

Regards

Bob



--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

No, sorry, I meant that someone else yesterday said, "only REAL
programmers...", and Nate's comment REMINDED me of that. But I wasn't
putting words into his mouth. Oh well, I guess I shouldn't have jumped in!

What me? I didn't say '...the way most experienced VB[A] developers would'

Hello!! I wasn't talking about YOU, I was talking about somebody else.

 

[Bob Phillips]

Whew! I thought you had jumped in to support me, then I got confused <ebg>

Regards

Bob

No, sorry, I meant that someone else yesterday said, "only REAL
programmers...", and Nate's comment REMINDED me of that. But I wasn't
putting words into his mouth. Oh well, I guess I shouldn't have jumped in!

What me? I didn't say '...the way most experienced VB[A] developers would'

Hello!! I wasn't talking about YOU, I was talking about somebody else.

:

And, it was qualified with the word 'most'. So, please don't be too quick to
put words in my mouth.

 

[Guest]

Tom,
You're right, that isn't what I literally asked. I thought my final
statement implied a replacement of the 'Month' variable prior to evaluation.
I didn't mean to mislead.

Sorry for the confusion.

Regards,
VBA Dabbler