+ Reply to Thread
Results 1 to 2 of 2

Transfer specific data on specific worksheet using userform

  1. #1
    Registered User
    Join Date
    08-14-2010
    Location
    mauritius
    MS-Off Ver
    Excel 2007
    Posts
    3

    Red face Transfer specific data on specific worksheet using userform

    Hi everybody.

    i have a userform with 5 textbox, in the last 2 textboxes, i have date and time consecutively.. i have already insert a vb code which will enable me to transfer data to a worksheet. it works fine, i want to have a vb code so that when for e.g, i insert 1248(employee no.) in the first textbox, all which follows the next 4 textboxes will enter in spreadsheet 1248 when i click on post button, and the form will be cleared.same for the other employee number. i have already did it refer as attachment, but all enters in the same worksheet.I already rename 5 spreadsheet 1248,1243..etc. how to transfer the employee number to its specific worksheet i.e 1248,1243..., as i really dont know how to do it, or if its possible

    Please help me, its important , im trying to do a time clocking.

    Thanks all
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-14-2010
    Location
    mauritius
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Transfer specific data on specific worksheet using userform

    Please help this peron please as he badly needded

+ 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