Should be an easy one. Using an Or Syntax.

d-alan · Apr 3rd, 2002, 10:22 AM

I want to check if a combobox has one of two value before it runs a function.
I know &, +, is there an Or function that can be applied. I can not seem to find any reference to a syntax to use.
The following comes back with a typemismatch.
If combobox1.Text = ("Crit1") Or ("Crit2") Then

Ricky Morris · Apr 3rd, 2002, 10:26 AM

Try:

If combobox1.Text = ("Crit1") Or combobox1.Text = ("Crit2") Then

d-alan · Apr 3rd, 2002, 10:35 AM

Worked like a charm.
THANKS

Apr 3rd, 2002, 10:26 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try: If combobox1.Text = ("Crit1") Or combobox1.Text = ("Crit2") Then __________________ It's never too late to learn something new. Ricky

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

Apr 3rd, 2002, 10:22 AM	#1
d-alan Board Regular Join Date: Mar 2002 Posts: 119	I want to check if a combobox has one of two value before it runs a function. I know &, +, is there an Or function that can be applied. I can not seem to find any reference to a syntax to use. The following comes back with a typemismatch. If combobox1.Text = ("Crit1") Or ("Crit2") Then

Apr 3rd, 2002, 10:35 AM	#3
d-alan Board Regular Join Date: Mar 2002 Posts: 119	Worked like a charm. THANKS