Consulting

Results 1 to 7 of 7

Thread: Unrelated User Entry Pause

  1. #1
    VBAX Newbie
    Joined
    Jun 2024
    Posts
    2
    Location

    Unrelated User Entry Pause

    Hello VBA community!


    I come to you today with (ideally) a simple dilemma with (hopefully) a simple solution.


    Question: Based on this scenario and the problem below, is there a way to either (1) push a write while the user writes into a cell without interrupting their input or (2) making the macro wait while a user inputs data into a cell as part of an unrelated process?


    Scenario: I have a created a fully automated process that executes requests in an external database and returns results back into a log in Excel. The program takes several hours to complete but I have other tasks I must complete in other Excel spreadsheets.


    Problem: While the program is running, data entry in other spreadsheets appear to suspend the connection of the Excel object write. This makes the log have skipped items. This occurs when either (1) highlighting a cell or (2) taking focus for user input into a cell. This results in cells not being written to while writing in another cell.

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,189
    Location
    Welcome to VBAX susancur. As i understand it Excel only accepts one cell having the focus at a time (in relation to writing to the cell). Would it be possible to conduct your inputs to a back up copy then when finished update the main workbook?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,744
    Location
    Quote Originally Posted by susancur View Post
    I have other tasks I must complete in other Excel spreadsheets.
    You can have more than one instance of Excel running at one time, so I'd suggest you start the long process in one instance and then use another for your other work while that runs in the background.
    Be as you wish to seem

  4. #4
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,911
    Ways to open a new instance of Excel:
    https://exceloffthegrid.com/how-to-o...nces-of-excel/
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  5. #5
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,189
    Location
    Hmmm.... there's something familiar about this thread. susancur, did you post this thread elsewhere by any chance?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  6. #6
    VBAX Newbie
    Joined
    Jun 2024
    Posts
    2
    Location
    Quote Originally Posted by Aflatoon View Post
    You can have more than one instance of Excel running at one time, so I'd suggest you start the long process in one instance and then use another for your other work while that runs in the background.
    Oh, it worked. Many thanks!

  7. #7
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,189
    Location
    Cross posting without letting others know is disrespectful to those members here who have assisted you susancur. Would be a shame if you gained a reputation for doing so.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •