elseif

C

Curt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass condition formatting across worksheets via vba. 0
target value 1
triogger reset 0
chg by val 1
conflict with code 7
order placement of code 0
how to have 2 drop down lists filter rows 2
clear contents re value 9

Top