C
Cyntalan
What I'm currently trying to do is what would normally seem like a
pause request (as it would seem by the search I did before this post).
However, nothing seemed to match what I'm attempting to do.
I have in mind a series of sort, copy/paste, and other similar simple
time-saver style scripts that I want to have executed in a set order at
the user's confirmation. Between each confirmation, the user will have
to manipulate the spreadsheet in a way that can, and will, change a
lot. This means a simple InputBox will not do. The user must review the
sheet, pick and choose what they need to edit, and otherwise be able to
freely manipulate it, then execute the next script. As of now, the only
way I have to do this is to execute each script at its own calling.
What I would like to do is have some sort of form appear that will
standby and wait for the user to be done with whatever they needed to
do, then click a button to go to the next point of manipulation.
However, calling a UserForm or any kind of dialog box requires its
closure to be able to continue spreadsheet manipulation. Is this
concept possible, or is manual script calling the only way I can manage
this?
pause request (as it would seem by the search I did before this post).
However, nothing seemed to match what I'm attempting to do.
I have in mind a series of sort, copy/paste, and other similar simple
time-saver style scripts that I want to have executed in a set order at
the user's confirmation. Between each confirmation, the user will have
to manipulate the spreadsheet in a way that can, and will, change a
lot. This means a simple InputBox will not do. The user must review the
sheet, pick and choose what they need to edit, and otherwise be able to
freely manipulate it, then execute the next script. As of now, the only
way I have to do this is to execute each script at its own calling.
What I would like to do is have some sort of form appear that will
standby and wait for the user to be done with whatever they needed to
do, then click a button to go to the next point of manipulation.
However, calling a UserForm or any kind of dialog box requires its
closure to be able to continue spreadsheet manipulation. Is this
concept possible, or is manual script calling the only way I can manage
this?