Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > 'OR' Condition
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 29
Default 'OR' Condition
Hi,
Is there a limit to the no of 'OR's in a statement, cos in the below condition
the 1st 6 conditions get checked, but not the last checking criteria
[*****],refer below.
(also another simple Q, how can i break the lenght of the code
& continue typing it on a next line ?)

If Me.CboSubType.Value = "Blue" Or
Me.CboSubType.Value = "Blue MGM" Or
Me.CboSubType.Value = "Gold" Or
Me.CboSubType.Value = "Gold MGM" Or
Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]" Or
Me.CboSubType.Value = "Citi-Plus" Or
Me.CboSubType.Value = "CG Fee Account" [*******] doesnt check this ! !
AND
Me.CboType = "New to Bank" Then
Me.Label7.Visible = False
Me.txtVlu.Visible = False
Else
Me.Label7.Visible = True
Me.txtVlu.Visible = True
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 9,101
Default 'OR' Condition
Easy

TempOR1 = (Me.CboSubType.Value = "Blue") Or _
(Me.CboSubType.Value = "Blue MGM") Or _
(Me.CboSubType.Value = "Gold") Or _
(Me.CboSubType.Value = "Gold MGM")

TempOR2 = (Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]") Or _
(Me.CboSubType.Value = "Citi-Plus") Or _
(Me.CboSubType.Value = "CG Fee Account")

if (TempOR1 or TempOR2) and (Me.CboType = "New to Bank") then
Me.Label7.Visible = False
Me.txtVlu.Visible = False
Else
Me.Label7.Visible = True
Me.txtVlu.Visible = True

"Matts" wrote:

Hi,
Is there a limit to the no of 'OR's in a statement, cos in the below condition
the 1st 6 conditions get checked, but not the last checking criteria
[*****],refer below.
(also another simple Q, how can i break the lenght of the code
& continue typing it on a next line ?)

If Me.CboSubType.Value = "Blue" Or
Me.CboSubType.Value = "Blue MGM" Or
Me.CboSubType.Value = "Gold" Or
Me.CboSubType.Value = "Gold MGM" Or
Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]" Or
Me.CboSubType.Value = "Citi-Plus" Or
Me.CboSubType.Value = "CG Fee Account" [*******] doesnt check this ! !
AND
Me.CboType = "New to Bank" Then
Me.Label7.Visible = False
Me.txtVlu.Visible = False
Else
Me.Label7.Visible = True
Me.txtVlu.Visible = True
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 29
Default 'OR' Condition
Hi Joel,
Only the first half is getting checked (TempOR1).
Doesnt seem to work for the values in the (TempOR2) argument.

What next ?

"Joel" wrote:

Easy

TempOR1 = (Me.CboSubType.Value = "Blue") Or _
(Me.CboSubType.Value = "Blue MGM") Or _
(Me.CboSubType.Value = "Gold") Or _
(Me.CboSubType.Value = "Gold MGM")

TempOR2 = (Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]") Or _
(Me.CboSubType.Value = "Citi-Plus") Or _
(Me.CboSubType.Value = "CG Fee Account")

if (TempOR1 or TempOR2) and (Me.CboType = "New to Bank") then
Me.Label7.Visible = False
Me.txtVlu.Visible = False
Else
Me.Label7.Visible = True
Me.txtVlu.Visible = True

"Matts" wrote:

Hi,
Is there a limit to the no of 'OR's in a statement, cos in the below condition
the 1st 6 conditions get checked, but not the last checking criteria
[*****],refer below.
(also another simple Q, how can i break the lenght of the code
& continue typing it on a next line ?)

If Me.CboSubType.Value = "Blue" Or
Me.CboSubType.Value = "Blue MGM" Or
Me.CboSubType.Value = "Gold" Or
Me.CboSubType.Value = "Gold MGM" Or
Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]" Or
Me.CboSubType.Value = "Citi-Plus" Or
Me.CboSubType.Value = "CG Fee Account" [*******] doesnt check this ! !
AND
Me.CboType = "New to Bank" Then
Me.Label7.Visible = False
Me.txtVlu.Visible = False
Else
Me.Label7.Visible = True
Me.txtVlu.Visible = True
Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 9,101
Default 'OR' Condition
As I thought, the problem wasn't with the number of ORs strung together. The
is either a typo, a exttra blank character or an invisible character in the
string you are searching.

try something like this

for i = 1 to len(mystring)
msgbox("Char: " & i & "=" & _
mid(mystring,1,1) & "=" & _
asc(mid(mystring,1,1)))
next i

"Matts" wrote:

Hi Joel,
Only the first half is getting checked (TempOR1).
Doesnt seem to work for the values in the (TempOR2) argument.

What next ?

"Joel" wrote:

Easy

TempOR1 = (Me.CboSubType.Value = "Blue") Or _
(Me.CboSubType.Value = "Blue MGM") Or _
(Me.CboSubType.Value = "Gold") Or _
(Me.CboSubType.Value = "Gold MGM")

TempOR2 = (Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]") Or _
(Me.CboSubType.Value = "Citi-Plus") Or _
(Me.CboSubType.Value = "CG Fee Account")

if (TempOR1 or TempOR2) and (Me.CboType = "New to Bank") then
Me.Label7.Visible = False
Me.txtVlu.Visible = False
Else
Me.Label7.Visible = True
Me.txtVlu.Visible = True

"Matts" wrote:

Hi,
Is there a limit to the no of 'OR's in a statement, cos in the below condition
the 1st 6 conditions get checked, but not the last checking criteria
[*****],refer below.
(also another simple Q, how can i break the lenght of the code
& continue typing it on a next line ?)

If Me.CboSubType.Value = "Blue" Or
Me.CboSubType.Value = "Blue MGM" Or
Me.CboSubType.Value = "Gold" Or
Me.CboSubType.Value = "Gold MGM" Or
Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]" Or
Me.CboSubType.Value = "Citi-Plus" Or
Me.CboSubType.Value = "CG Fee Account" [*******] doesnt check this ! !
AND
Me.CboType = "New to Bank" Then
Me.Label7.Visible = False
Me.txtVlu.Visible = False
Else
Me.Label7.Visible = True
Me.txtVlu.Visible = True
Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 29
Default 'OR' Condition
Your right Joel. Was a character mismatch.
Thanks a ton. Works brilliant.

"Joel" wrote:

As I thought, the problem wasn't with the number of ORs strung together. The
is either a typo, a exttra blank character or an invisible character in the
string you are searching.

try something like this

for i = 1 to len(mystring)
msgbox("Char: " & i & "=" & _
mid(mystring,1,1) & "=" & _
asc(mid(mystring,1,1)))
next i

"Matts" wrote:

Hi Joel,
Only the first half is getting checked (TempOR1).
Doesnt seem to work for the values in the (TempOR2) argument.

What next ?

"Joel" wrote:

Easy

TempOR1 = (Me.CboSubType.Value = "Blue") Or _
(Me.CboSubType.Value = "Blue MGM") Or _
(Me.CboSubType.Value = "Gold") Or _
(Me.CboSubType.Value = "Gold MGM")

TempOR2 = (Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]") Or _
(Me.CboSubType.Value = "Citi-Plus") Or _
(Me.CboSubType.Value = "CG Fee Account")

if (TempOR1 or TempOR2) and (Me.CboType = "New to Bank") then
Me.Label7.Visible = False
Me.txtVlu.Visible = False
Else
Me.Label7.Visible = True
Me.txtVlu.Visible = True

"Matts" wrote:

Hi,
Is there a limit to the no of 'OR's in a statement, cos in the below condition
the 1st 6 conditions get checked, but not the last checking criteria
[*****],refer below.
(also another simple Q, how can i break the lenght of the code
& continue typing it on a next line ?)

If Me.CboSubType.Value = "Blue" Or
Me.CboSubType.Value = "Blue MGM" Or
Me.CboSubType.Value = "Gold" Or
Me.CboSubType.Value = "Gold MGM" Or
Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]" Or
Me.CboSubType.Value = "Citi-Plus" Or
Me.CboSubType.Value = "CG Fee Account" [*******] doesnt check this ! !
AND
Me.CboType = "New to Bank" Then
Me.Label7.Visible = False
Me.txtVlu.Visible = False
Else
Me.Label7.Visible = True
Me.txtVlu.Visible = True
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup with multiple condition, but one condition to satisfy is en Eddy Stan Excel Worksheet Functions 2 October 27th 07 02:06 PM
Combine an OR condition with an AND condition Will Excel Discussion (Misc queries) 1 April 6th 07 03:52 PM
IF condition MIchel Khennafi Excel Worksheet Functions 3 April 17th 06 09:30 PM
Condition 1 overules condition 2? Bultgren Excel Worksheet Functions 2 January 20th 06 12:29 PM
I need 4 condition for condition formatting SeeKY Excel Programming 2 June 7th 05 09:41 AM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement