How du Case x twice? (Select Case)

Hi,

i wonder how I can case for ex. x twice? Right not I have the script:

Please Login or Register  to view this content.

For example I want to:

Please Login or Register  to view this content.

Thnx in advance!

Hmm.. I have working with arrays (little bit) but I thought I could solve it much more simple. In C# you can use Break statement to solve it. Dunno how to do it in VBA. Can you give me an example on an nice array to use in this case?

Bts, hos does your Commercial Services work? What kind of support will I get if I pay for the CS? Everything need to be posted in the Forum or is it PMs?

Thnx!

Originally Posted by JBeaucaire

NameX cannot really have two different values in it unless you declare the function as an array and fill/Redim the array as you add each element into the array. If you haven't worked out dealing with arrays, it's major step up in coding.

Perhaps this a red herring. What's this function really for? You may need to revamp this whole process you're developing to keep it simple.

Hi

Sorry I meant Switch!
I want to return two values based on one of the case - in this ex. Case A return both Albert and Avery

Thnx!!

Originally Posted by Norie

What is the purpose of the function?

Do you want to return 2 values based on the argument Ex passed to the function?

PS I don't see how Break would solve this, all it does is terminate a loop or switch.

Thank you so, so, SO much!!!!!!!!!! Will try it !

Originally Posted by Norie

You could do it like this, which will return an array with the 2 names based on Ex.

Please Login or Register  to view this content.

Hi again!

I tried you ex but didn't work - It only writes Albert and not Avery. Something spec. I need to think at?

Thnx!

Originally Posted by Norie

You could do it like this, which will return an array with the 2 names based on Ex.

Please Login or Register  to view this content.