multiconditional code
Posted by amroo on April 26, 2001 12:30 AM
Bonjour,
I want to know if it's possible to code as this:
if ID=(12 or 14 or 23 or 32) then ....
else what is the solution?
a+mroo(the sign + means see you later in french).
Posted by Malc on April 26, 2001 12:37 AM
=if(or(A1=12,A1=14,A1=23,A1=32),"It's here","It's not here)
If ID is a range name substitute A1 for the rangename.
Haerera (or however it's spelt) means see ya later
Posted by Dave Hawley on April 26, 2001 2:03 AM
Hi Amroo
Best to use a Select Case statement for this, see below:
Sub Choice()
Select Case Id
Case 12, 14, 23, 14
'Your Code!
End Select
End Sub
Dave
OzGrid Business Applications
Posted by Dave Hawley on April 26, 2001 2:10 AM
Didn't see your ELSE :o)
Sub Choice()
Select Case Id
Case 12, 14, 23, 14
'Your Code!
Case Else
'Do something else
End Select
End Sub
+
OzGrid Business Applications
Posted by Aladin Akyurek on April 26, 2001 2:28 AM
If you are interested in building formulas, then here is an example:
=IF(OR(ID={12,14,23,32},...)
where ID is the name of the cell to be evaluated.
Salut.
Aladin Bonjour,
Posted by amroo on April 27, 2001 12:20 AM
I have to precise that the numbers 12 or 32 etc... are values in a combobox not range of cells. So when I click on one of them a conditional action runs.
Am I clear?
Amroo
