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?
Anyone who confuses correlation and causation ends up dead.
It won't accept it
What code are you using? It should do.
My error!!!!! sorry
On Error GoTo exit_proc qty = InputBox("Enter quantity required") 'if negative then try again If qty < 1 Then GoTo get_qty
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