I'm trying to exit my macro if I click 'Cancel' in an input box :
Both of these work , and exit the macro correctly when I click cancel.Please Login or Register to view this content.
Unfortunately , if the number I enter into the second box happens to be a zero , it exits also.
Is there a way to have a Double variable cancel when I click the button , but allow me to enter a zero?
Grateful for any help.
Bookmarks