gratefulwork
10-23-2018, 01:56 PM
Hi there,
In Excel VBA, I have a message box that must only accept negative, odd, double digit numbers, and then sum all numbers from the inputted number to zero. I have taken a portion of code from online and have been trying to modify it to my situation. So far, I am able to get the negative portion to work, so the input only accepts negative numbers. I have also been able to get even numbers on with Mod 2 = 0, however Mod 2 = 1 does not change it is odd numbers only. As well, I have no idea how to go about having the message box only accept double digit numbers. I think it has something to do with Len(2) but I am unsure how to implement it.
I have attached my workbook below. Any help is greatly appreciated.
23079
In Excel VBA, I have a message box that must only accept negative, odd, double digit numbers, and then sum all numbers from the inputted number to zero. I have taken a portion of code from online and have been trying to modify it to my situation. So far, I am able to get the negative portion to work, so the input only accepts negative numbers. I have also been able to get even numbers on with Mod 2 = 0, however Mod 2 = 1 does not change it is odd numbers only. As well, I have no idea how to go about having the message box only accept double digit numbers. I think it has something to do with Len(2) but I am unsure how to implement it.
I have attached my workbook below. Any help is greatly appreciated.
23079