Rayne
asked on
limitMyEntry
Hello All,
I am looking for a worksheet change event:
Requirements:
1. For columns C and F, users cannot enter negative numbers
2. If users enter negative, target.value becomes 0 and prompts users with message
3. If user either enter numbers for C or F, the column H of that row will get TRUE for the update.
thanks
limitInput.xlsx
I am looking for a worksheet change event:
Requirements:
1. For columns C and F, users cannot enter negative numbers
2. If users enter negative, target.value becomes 0 and prompts users with message
3. If user either enter numbers for C or F, the column H of that row will get TRUE for the update.
thanks
limitInput.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER