Repeating code

Hi

Please be gentle - after 10 years since I hung up my VBA programming hat, I've jumped back in it and to be fair I am really struggling. What I am after is probably dead easy but I need some help please

Below is my code

Please Login or Register  to view this content.

----Basically what I am after is if the value entered is blank then the error message appears and the input box appears again until either a value is entered or the use clicks cancel.

My head is really hurting, Can someone please help and fill in the missing code as appose to telling me how to do it, cause at this point in time I just cant get my head round it from reading the VBA examples.

Welcome to the forum.

Maybe like this:

Please Login or Register  to view this content.

Without changing too much of what you wrote... this should do the trick.

Please Login or Register  to view this content.