+ Reply to Thread
Results 1 to 2 of 2

User form on initialize to recall last entry from Excel Sheet

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    PNG
    MS-Off Ver
    Excel 2010
    Posts
    1

    User form on initialize to recall last entry from Excel Sheet

    Hi, I have a user form that posts information to a data sheet, this is done daily. I want the added function of the user form, when initialized by the user, to retrieve (from the data sheet) and show certain values (in rows 5,8,11,14,17&20) that were entered in the day before. I am a novice at this stage and don't know where to start. A copy of the Excel file is attached, please help!
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: User form on initialize to recall last entry from Excel Sheet

    This may be what you are after,
    Goes in the "AMIOPPlan" UserForm module,
    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)

Similar Threads

  1. Calling a user form initialize sub when entering the form to populate combobox...
    By regupnorth in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-02-2012, 07:24 AM
  2. [SOLVED] Recall function to a User Form
    By shnim1 in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 02:47 AM
  3. User Form Initialize Event Issues
    By Randy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-04-2005, 07:30 AM
  4. [SOLVED] initialize form field from previous entry
    By vince c via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2005, 03:07 PM
  5. Closing user form in Initialize macro?
    By Don Wiss in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2005, 04: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