If inputbox = false then repeat inputbox

[Excelnoub]

Good day everyone,
I have the following code:

Please Login or Register  to view this content.

I need to add something that if user doesnt add a number (code in place) then it will clear the active cell but also bring it back to the inputbox application.

So lets say a user inserts a letter it will give the message "Sorry, only numbers allowed." with an OK button...(Already there) but then will go back to the "NumberOfContracts" inputbox.

I had something yesterday but lost it, something with repeat: and goto repeat but now I'm lost in where to add it.

Please help, Thank you

[Excelnoub]

I had this and it was working great without the

Please Login or Register  to view this content.

Please Login or Register  to view this content.

But I need to have the If B5:B30 then

Why that now it's not working but when I change the, If Not Intersect(Target, Range("A5:A30")) Is Nothing Then, it doesn work?

[Jakobshavn]

Here is some simple logic to demand a number:

Please Login or Register  to view this content.

[Excelnoub]

I tweeked my code to the following and works well but thank you Jakob

Please Login or Register  to view this content.

Excelnoub