Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
elseif
useing code that follows have tried to have code call copycomp sometimes will
also code changes all entries to 0 not sure where to go stumped. Think there should be a way to use elseif. Tried to no avail. Want column to be as code calls for. Have 3 calls befor this one that work fine. Thanks If Target.Column = 12 And Target.Value <= 0 And IsNumeric(Target.Value) Then _ Call Copycomp(Target) 'do this then'_ If Target.Column = (12) <= 0 Then _ Target.Value = 0 If Target.Column = (12) = 10 Then _ Target.Value = 10 ' End If ' If Target.Column = (12) And Target.Value < 10 Then ' Target.Value = 10 ' If Target.Column = 12 And Target.Value <= 0 Then _ ' Target.Value = 0 Application.EnableEvents = True ' End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
elseif | Excel Programming | |||
IF..Then..ELSE.. ELSEIF | Excel Programming | |||
If, ElseIf | Excel Programming | |||
ElseIf | Excel Programming | |||
If...Elseif...End If | Excel Programming |