Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking multiple scripts by user OK
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking multiple scripts by user OK
Make the Show the userform vbModeless, so the user can still interact with
the Ws whilst it is showing. NickHK "Cyntalan" wrote in message ups.com... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete scripts | Excel Worksheet Functions | |||
linking multiple roles (rows) to a user (cell) | Excel Discussion (Misc queries) | |||
Forumlas or scripts? | Excel Discussion (Misc queries) | |||
SQL Scripts in Excel | Excel Discussion (Misc queries) | |||
Macintosh and VB Scripts | Excel Programming |