elseif
Thank you I blanked
curt "Curt" wrote: 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 |
All times are GMT +1. The time now is 01:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com