+ Reply to Thread
Results 1 to 2 of 2

VBA wait until user Input

  1. #1
    Forum Contributor
    Join Date
    04-14-2017
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    148

    VBA wait until user Input

    Good Day

    I have this userform whereby I am able to add, delete without any problems. The edit workflow is as follows:

    1. The user click on the edit Button
    2. The user will be prompted to Enter a password to edit the data
    3. Password Accept Message box appears
    4. The userform unlocks certain editable fields
    5. The user must be able to edit exiting data at this POINT
    6. The is user prompted to accept that the changes
    7. Progress is called to update data
    8. Form is refreshed

    The issue I am having is with Item 5 (whereby it is not allowing me to edit the data and continue from step 6 onwards)
    Below is the code:

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: VBA wait until user Input

    You end the Image12_Click procedure at step 5. Then have an command button that is OK or Accept that does the rest of the code after step 5.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 08-18-2013, 12:23 PM
  2. [SOLVED] Halt macro - wait for user input
    By The Skipper in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2013, 03:26 PM
  3. [SOLVED] help with for loops; wait for user input
    By etuckram in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2013, 04:24 AM
  4. [SOLVED] Pop Up Box - Wait for Range input - Continue Macro
    By The Skipper in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2013, 04:41 PM
  5. Macro wait for input.
    By SBA lender in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2011, 03:24 PM
  6. Replies: 1
    Last Post: 09-29-2005, 08:05 AM
  7. Wait for user response
    By Brisbane Rob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2005, 05:31 PM
  8. [SOLVED] i want a macro in execl to wait for an input from the user.
    By toiletman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2005, 10:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1