Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
IF condition | Excel Worksheet Functions | |||
Condition 1 overules condition 2? | Excel Worksheet Functions | |||
I need 4 condition for condition formatting | Excel Programming |