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

"salgud" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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.