+ Reply to Thread
Results 1 to 4 of 4

TextBox on UserForm to display the last entry

  1. #1
    Registered User
    Join Date
    11-23-2006
    Posts
    6

    Question TextBox on UserForm to display the last entry


    I would like to add a textbox to my userform that would populate with the name previously entered before clicking on the command button that's coded to send the data to the specified worksheet. This would allow my staff to be sure of where they were with data entry in case they are called away or have to pause. Is this do-able?

    Thanks in advance for any guidance,

    Jenn

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628
    An idea may be this (insert a label on your form and in the command button insert this code):

    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    where TextBox1 is the textbox in wich you insert sheet destination.


    Regards,
    Antonio

  3. #3
    Registered User
    Join Date
    11-23-2006
    Posts
    6

    Thumbs up

    Thanks so much for your help! It didn't work at first but I added
    UserForm1 to the beginning of the code and it worked perfectly!

    UserForm1.Label26.Caption = TextBox1.Text

    Thanks again!

    Jenn

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    You could also use
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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