Hi, I'm using an Application InputBox to insert numbers into a worksheet, mostly these are + numbers but on the odd occasion they maybe minus numbers. is it possible to formulate the inputbox to accept + and - values?
Hi, I'm using an Application InputBox to insert numbers into a worksheet, mostly these are + numbers but on the odd occasion they maybe minus numbers. is it possible to formulate the inputbox to accept + and - values?
Last edited by zimbo109; 05-27-2010 at 03:44 AM.
Why can't you just enter a negative number?
Remember what the dormouse said
Feed your head
It won't accept it
What code are you using? It should do.
My error!!!!! sorry
Please Login or Register to view this content.
I had no problem getting a negative, what is the type of 'qty'? Is it an integer?
You've designed your code not to accept negative numbers, assuming get_qty restarts the InputBox.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks