Retry Logic

[grkchakri]

Hi All

I have a userform with a text box & command button. Idea is when the user clicks the command button with out any data in the text box
message pops every time to inform that data should be present before clicking that add button.
A max of three times user can click beyond which the code closes the application.

Need help in that retry logic what should we do so that i is counted each time and third time is the last chance. the attachment contains only one sheet
and one userform.

Thank you all

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[grkchakri]

Thank you very much Mumps and Fulfyy totally agree with both your solutions.

But just in case if i have write something for a retry logic when i capture the error(retry) how to do that.

[Fluff13]

There is no error to capture, so not quite sure what you mean.

[grkchakri]

let say while xy as integer operator had entered alphabet and we want that error to be captured. and if user keeps on entering that thrice then we should close the userform . would that be a scneario where we have captured error.

[Fluff13]

Sorry, but I don't understand.
Whilst you have declared XY as integer, you have never assigned it a value.

[grkchakri]

Apologies got confused between the data item and the text box values. your logic stands good , hence closing it as solved. thank you once again.

[Fluff13]

You're welcome & thanks for the feedback.