+ Reply to Thread
Results 1 to 4 of 4

Excel Userform with edit function

  1. #1
    Registered User
    Join Date
    01-20-2015
    Location
    Hong Kong
    MS-Off Ver
    2010
    Posts
    36

    Excel Userform with edit function

    I have made a database and a userform template as attached, but i am new on vba.
    I would like to make the userform which can input new and edit old record. when i search the staff then the bottom show the staff detail and can be edit.
    Would anyone help please?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Excel Userform with edit function

    Ok to start with

    You need to automate your Data Sort and Remove Duplicates method.

    Add this to your List sheet, Sheet specific macro module


    Please Login or Register  to view this content.

    Add this to a Macro module

    Please Login or Register  to view this content.

    I have renamed your Comboboxes. Giving then unique names does not help programming.

    The Data for your Comboboxes are in Columns 6 to 14 in steps of 2.

    I have named your comboboxes from 6 to 14 in steps of 2.

    Because of the regular names I can use a simple macro to load the Comboboxes

    Please Login or Register  to view this content.
    When the time comes we can use similar macros to load and to save our data.


    Please Login or Register  to view this content.

    I then created the Listbox click event, but had to make some changes to make it work like I wanted it to:

    Please Login or Register  to view this content.


    I added the Create new, Update and Clear routines.
    Thats all that I want to do here.

    I am going to look at simplifying the code and minimise it.

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 12-24-2016 at 09:19 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Excel Userform with edit function

    Ok this is the Modified File.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-20-2015
    Location
    Hong Kong
    MS-Off Ver
    2010
    Posts
    36

    Re: Excel Userform with edit function

    Thank you for yr great work. it nearly comes to my target. but can i add new staff by using the bottom? and can first show all details at the screen?

+ 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. [SOLVED] edit function on userform not functioning correctly
    By Learning ExL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2015, 04:25 AM
  2. Edit existing excel records using UserForm
    By bluesky63 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-28-2014, 03:18 AM
  3. Userform Edit function help Please
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-18-2014, 01:50 PM
  4. Retrieve data from excel in userform to edit
    By Daantje71 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2013, 03:06 PM
  5. VB coding for using excel userform to edit and overwrite an existing database
    By raseen20 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2013, 10:35 AM
  6. Help in creating an edit userform in excel vba
    By hasanbirol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2013, 10:49 AM
  7. Userform search and edit function help
    By adjustermn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2010, 03:35 PM

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