ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   'OR' Condition (https://www.excelbanter.com/excel-programming/394947-condition.html)

Matts
'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

joel
'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

Matts
'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

joel
'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

Matts
'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


All times are GMT +1. The time now is 06:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com