continue code

[stevesunfold]

hi gents

at the moment i have a piece of macro code that asks a question "have you done system?"
if i click yes it continues nicely
but if i click no it then takes me to the sheet that i need to enter the system number.
i then click another button that takes me back to the main page and asks the same question again. i obviously then click yes and it works really nicely.

basically when i click no it takes me to the sheet i need but instead of clicking the button that takes me back is there a piece of code that will just let the macro carry on?

regards

[davesexcel]

Is the input range a specific range?
Can you use an input box to input the data instead of going back to the sheet?
You are not giving us much to work on, lets see the code.

[Andy Pope]

If you are halting your code to allow user intervention you will need to alter your code to take this into account.

You can use a public variable to store the state of the macro execution.

This is only pseudo code.

Please Login or Register  to view this content.

If you need more help you will need to, as Dave points out, provide more information.

[stevesunfold]

thanks for the response guys
here is the code

Please Login or Register  to view this content.

[stevesunfold]

bump bump bump please

[Andy Pope]

Try this, although if the user may not have selected the system of delivery when the code is run for the second time.

Is there no way you can check that the delivery system has been chosen?

Please Login or Register  to view this content.

[stevesunfold]

hi andy

willc heck this when i get home
thanks for the reply
basically there are only a couple of users for this form so thats not really an issue