Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a macro be suspended during user input?
Can an Excel 97 subroutine be suspended while the user edits a cell?
My code would work like this: Set MyRange = [5 adjacent cells] For Each Cell in MyRange Insert a default value Place Excel into EDIT mode Select the entire cell contents 'For deletion/editing. Wait for the User to: Accept the default [OR] modify and accept it. End Wait Next Cell I cannot figure this one out. Sendkeys executes last in subroutine and thus is unacceptable. I prefer not to use UserForms or InputBoxes. David DeArmond *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a macro be suspended during user input?
No.
Regards, Tom Ogilvy David DeArmond wrote in message ... Can an Excel 97 subroutine be suspended while the user edits a cell? My code would work like this: Set MyRange = [5 adjacent cells] For Each Cell in MyRange Insert a default value Place Excel into EDIT mode Select the entire cell contents 'For deletion/editing. Wait for the User to: Accept the default [OR] modify and accept it. End Wait Next Cell I cannot figure this one out. Sendkeys executes last in subroutine and thus is unacceptable. I prefer not to use UserForms or InputBoxes. David DeArmond *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a macro be suspended during user input?
Thanks, Tom.
I appreciate your [to the point] answers and your time. If I may ask, what would you do, in this case? My outlook is to userforms with placement and size to match the user's screen resolution and ActiveCell.Top, ActiveCell.Left. Do you agree? Thanks, David D. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need macro to post data from user input | Excel Worksheet Functions | |||
macro to save as a data input by user file name from a designated | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
Macro for user to input 10 numbers | New Users to Excel | |||
Macro to pause for user input in dialog box | Excel Discussion (Misc queries) |