Looping 2 msgboxes

[Maxwelll]

I am trying to loop 2 msgbox's by asking if you would like to try again. I assumed this was a simple task but I cannot figure out to restart the process again. Does anyone have a solution for this?

Please Login or Register  to view this content.

[6StringJazzer]

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you only have a few posts. --6StringJazzer

I think this will get you there but it would be helpful if you posted all the code instead of just this snippet.

Please Login or Register  to view this content.

Note that once you get to here, you might not have valid job files, if they gave a bad job number and said "No" for try again. That was also a problem in your original code.

You can enhance this if you can determine all the valid job numbers in advance, then give the user a list to choose from instead of having them type something in that might not exist.

[JOHN H. DAVIS]

Please review the Forum Rules. Specifically Rule No. 3 about using code tags when posting code.

http://www.excelforum.com/forum-rule...rum-rules.html

Try using Goto to solve your problem:

Please Login or Register  to view this content.

[AlphaFrog]

jobNumber = MsgBox("Enter the job number. Be sure to have the proper file downloaded", "Job number", "Enter job number here", Type:=1)

Can't enter a value in a MsgBox.

Try this...

Please Login or Register  to view this content.

[Maxwelll]

basically it is the beginning of a service report for my company. Our dispatcher emails out an excel sheet with all of the service call information and calls it a specific job number. This sheet will eventually import all of the information into a template I made. The job number will always be different. Here is all of the code I made so far. I found a way to make it work by starting the sub over.

Please Login or Register  to view this content.

[Maxwelll]

Sorry I knew about the msgbox. I was trying something different right before I started the post. This last one was my origional

[6StringJazzer]

Maxwelll, I already notified you about code tags above. Now I have to insist that you edit post #5 to conform to the rules.

Your post does not comply with Rule 3 of our Forum Rules: Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7.

[Maxwelll]

My apologies. I did not know about the rule and did not notice your post.

Issue resolved

[AlphaFrog]

Did you try the code in post #4 ?