#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    new mexico
    Posts
    4
    Rep Power
    0

    Pause for user input


    How do I code a pause in an Excel macro (VB) so that after it takes the user to another worksheet, it pauses and allows one scroll and select a cell and then copies that cell to the originating worksheet cell after the return key is pressed?
    Last edited by dialarc; May 10th, 2003 at 08:32 AM.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2001
    Location
    Dublin
    Posts
    413
    Rep Power
    14
    popup a userform with a select range text box on it, i reckon

IMN logo majestic logo threadwatch logo seochat tools logo