+ Reply to Thread
Results 1 to 2 of 2

Store texbox contents of last 3 entries

  1. #1
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Store texbox contents of last 3 entries

    Hi,

    I have a textbox that I am using to display locations that come in randomly from a worksheet depending on a job. The textbox then gets refreshed with new information every so often when another job is loaded to my userform. I can't quite figure out how to get the snapshot of the textbox assigned to a variable and then save it and then display the last 3 entries any time I need to.

    First Entry = Bin 4789
    Second Entry = Bin 2983
    Third Entry = Bin 7824

    I want a button to then display a msgbox "Bin 4789, Bin 2983, Bin 7824 were the last 3 entries"

    I have of course used:

    Please Login or Register  to view this content.
    How do I save LocA for later and prevent it from being overwritten on the next textbox entry?

    Thanks for any help!

  2. #2
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: Store texbox contents of last 3 entries

    Anyone have a thought on how to accomplish this? I am completely stuck. Thanks!

+ 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