vba case text string

Jack in the UK · May 24th, 2002, 04:35 AM

hi guys help me out im stuck

case is > 1

This is OK but what about

case is = jack

i cant seem to get case non interger

where am i going wrong?

cheers guys

Mudface · May 24th, 2002, 04:40 AM

It'd just be: -

Case "Jack"

I think. You might want to have an extra check in there to avoid type mismatches if you could have numbers and strings being checked.

Jack in the UK · May 24th, 2002, 05:13 AM

Solved

thanks

will post later.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 04:35 AM	#1
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	hi guys help me out im stuck case is > 1 This is OK but what about case is = jack i cant seem to get case non interger where am i going wrong? cheers guys

May 24th, 2002, 04:40 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	It'd just be: - Case "Jack" I think. You might want to have an extra check in there to avoid type mismatches if you could have numbers and strings being checked.

May 24th, 2002, 05:13 AM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Solved thanks will post later.