I have played with it for an hour, but can't figure out how to make a case
statement that would be something like:

Case is = (string1 contains string2)

Is there a way to do this?
Thanks!

Look in the vba help index for
INSTR

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"salgud" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have played with it for an hour, but can't figure out how to make a case
> statement that would be something like:
>
> Case is = (string1 contains string2)
>
> Is there a way to do this?
> Thanks!

simplistic, but may give you an idea, since you didn't provide much.

Sub test()
Select Case True
Case InStr(1, "this is a test", "tst")
Debug.Print "True"
Case Else
Debug.Print "False"
End Select
End Sub


--


Gary Keramidas
Excel 2003


"salgud" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have played with it for an hour, but can't figure out how to make a case
> statement that would be something like:
>
> Case is = (string1 contains string2)
>
> Is there a way to do this?
> Thanks!

Try

Select Case True

Case string1 Like "*string2*"

etc.
End Select

--

HTH

Bob

"salgud" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have played with it for an hour, but can't figure out how to make a case
> statement that would be something like:
>
> Case is = (string1 contains string2)
>
> Is there a way to do this?
> Thanks!

On Mon, 22 Mar 2010 16:29:40 -0600, salgud wrote:

> I have played with it for an hour, but can't figure out how to make a case
> statement that would be something like:
>
> Case is = (string1 contains string2)
>
> Is there a way to do this?
> Thanks!

Thanks to all!

On Tue, 23 Mar 2010 07:38:15 -0600, salgud wrote:

> On Mon, 22 Mar 2010 16:29:40 -0600, salgud wrote:
>
>> I have played with it for an hour, but can't figure out how to make a case
>> statement that would be something like:
>>
>> Case is = (string1 contains string2)
>>
>> Is there a way to do this?
>> Thanks!
>
> Thanks to all!

Gave both methods a try, but neither works! I'm setting a case for
worksheets that have "Monthly" in their sheetname (sWsName)

I put in:

Case sWsName like "Monthly"

and

Case "Monthly" Like sWsName

and

Case instr(1,lcase(sWsName),"monthly")

and

Case InStr(1, sWsName, "Monthly")

Am I missing something?

Not much point us answering if you don't read it

Case sWsName like "*Monthly*"


--

HTH

Bob

"salgud" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Tue, 23 Mar 2010 07:38:15 -0600, salgud wrote:
>
>> On Mon, 22 Mar 2010 16:29:40 -0600, salgud wrote:
>>
>>> I have played with it for an hour, but can't figure out how to make a
>>> case
>>> statement that would be something like:
>>>
>>> Case is = (string1 contains string2)
>>>
>>> Is there a way to do this?
>>> Thanks!
>>
>> Thanks to all!
>
> Gave both methods a try, but neither works! I'm setting a case for
> worksheets that have "Monthly" in their sheetname (sWsName)
>
> I put in:
>
> Case sWsName like "Monthly"
>
> and
>
> Case "Monthly" Like sWsName
>
> and
>
> Case instr(1,lcase(sWsName),"monthly")
>
> and
>
> Case InStr(1, sWsName, "Monthly")
>
> Am I missing something?

On Tue, 23 Mar 2010 19:19:10 -0000, Bob Phillips wrote:

> Not much point us answering if you don't read it
>
> Case sWsName like "*Monthly*"

Thanks for your help.