+ Reply to Thread
Results 1 to 11 of 11

Help me to make user form for employees record with vba

  1. #1
    Registered User
    Join Date
    08-02-2010
    Location
    pakistan
    MS-Off Ver
    Excel 2003
    Posts
    8

    Help me to make user form for employees record with vba

    Dear Experts,

    attached file contains some dummy data to make form, kindly help as posible.

    actualy i m making database of workers using excel and want to make excel sheet form with these
    buttons (add, save, edit, search, <<first <previous next> last>>

    *ADD = to add new record of a fresh inductee
    *SAVE = to save record on other sheet as table
    *EDIT = to change any missing or incorrect data
    *SEARCH / RECALL = to view data with Emp. ID or complete name
    *<<FIRST = go to first record
    *<= go to previous one
    *>= go to next one
    *>>= go to last record

    in addition anything good for my database will be highly welcomed....
    note: please dont give advice to use readymade form of excel 2007 its not as per my requirement.


    thanks and best regards
    virgo
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-02-2010
    Location
    pakistan
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Help me to make user form for employees record with vba

    80 views no reply ...........
    Last edited by virgome; 04-19-2013 at 04:49 AM. Reason: reminder ....please help me to make user form

  3. #3
    Registered User
    Join Date
    08-02-2010
    Location
    pakistan
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Help me to make user form for employees record with vba

    Dear Experts,

    REMINDER PLEASE HELP .....WRITE VBA CODING ON BUTTONS TO MAKE A USER FORM


    attached file contains some dummy data to make form, kindly help as posible.

    actualy i m making database of workers using excel and want to make excel sheet form with these
    buttons (add, save, edit, search, <<first <previous next> last>>

    *ADD = to add new record of a fresh inductee
    *SAVE = to save record on other sheet as table
    *EDIT = to change any missing or incorrect data
    *SEARCH / RECALL = to view data with Emp. ID or complete name
    *<<FIRST = go to first record
    *<= go to previous one
    *>= go to next one
    *>>= go to last record

    in addition anything good for my database will be highly welcomed....
    note: please dont give advice to use readymade form of excel 2007 its not as per my requirement.


    thanks and best regards
    virgo
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Help me to make user form for employees record with vba

    Hi,

    I've started now but there is no "ADD" button in the form.

    Regards
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Help me to make user form for employees record with vba

    Hi virgome

    All you wish and even more is available here in the J & R Database Form. You simply need to adapt the Code to your Database.

    http://excel-it.com/vba_examples.htm
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  6. #6
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Help me to make user form for employees record with vba

    try that one:EMS-080413.xlsm

    Regards

  7. #7
    Registered User
    Join Date
    08-02-2010
    Location
    pakistan
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Help me to make user form for employees record with vba

    thank you so much sir, tehneXus,.....

    I m very glad

  8. #8
    Registered User
    Join Date
    11-28-2015
    Location
    Saudia
    MS-Off Ver
    2007
    Posts
    3

    Re: Help me to make user form for employees record with vba

    that one is not working at all. please send me the original one

  9. #9
    Registered User
    Join Date
    11-28-2015
    Location
    Saudia
    MS-Off Ver
    2007
    Posts
    3

    Re: Help me to make user form for employees record with vba

    i need the sheet which is already working and just i put all worker data on it

    i am very grateful to you

  10. #10
    Registered User
    Join Date
    11-28-2015
    Location
    Saudia
    MS-Off Ver
    2007
    Posts
    3

    Re: Help me to make user form for employees record with vba

    i am in need of that kind of sheet

  11. #11
    Registered User
    Join Date
    01-16-2014
    Location
    washington
    MS-Off Ver
    Excel 365 version 4209
    Posts
    72

    Re: Help me to make user form for employees record with vba

    For afzal tarar, I have been using the above form (from tehneXus) for about 5 months and it is working good. However, you do have to "enable macros" for it to work.

    I hope that helps.

+ 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