Programme interupt/break for manual data input 1

[KCarter]

Is there a way to interupt or make a break in a programme to allow for manual data input into a table, before resuming the programme?

VBA Visual Basic for Applications (Microsoft Excel)

 

[bryanbayfield]

You could put a break point in your code so that execution stops at that point, you could then press play in teh VBE to resume it.

However, that's not a practical solution if you're planning to release the workbook to other users. what might be an idea would be to have two macros - the first one execute then stops, the second one then executes by being linked to the worksheet change event, provided that certain cells have been manipulated first.

One other possible solution would be to have a form appear after the first half of your macro has finished. The form would have a spreadsheet control embedded into which would be read the data from the sheet the user is meant to alter. After manual input they could press the OK button on the form and teh second half of the macro would start.

Howzat?!