+ Reply to Thread
Results 1 to 3 of 3

User Form to dispaly last record in WorkSheet

  1. #1
    Forum Contributor vandanavai's Avatar
    Join Date
    09-04-2006
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    User Form to dispaly last record in WorkSheet

    Hello Everybody,

    I tried to search this but could not get answer to my difficult. May be I could not put proper word in search criteria.
    I have User Form to enter weekly data for work done by each employee. Folloing data is to be filled
    Date , Name of Employee, Nature of Work, No. of Hours worked.
    Once data entry for particular employee is started everytime Employee Name is to entered in testbox. Moreover most of the time Nature of Work done is same for 3-4 days in a week. What I want is that whenever any entry is made through User Form, same should be repeated in User Form. So that if any one filed is to changed it can be changed and there will not be any need to fill other details. This will save lot of time.
    Can this be done?

    Please help me.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485
    Hi,
    here's a sample Vlookup for the UserForm you could try out
    Attached Files Attached Files

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485
    in that example workbook,
    you will have to go to the userform in vba and run it from there
    as I forgot to create a macro to show the userform

+ 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