+ Reply to Thread
Results 1 to 3 of 3

edit function on userform not functioning correctly

  1. #1
    Forum Contributor
    Join Date
    03-30-2015
    Location
    Northampton
    MS-Off Ver
    2010
    Posts
    275

    edit function on userform not functioning correctly

    i have a userform and i thought this morning i would start going through everything to make sure it all worked correctly.

    my add, delete works great as supposed to but my edit button says my record has been updated but when i look, it has not. (i cant take the lies not more lol)

    here is my add button code then my edit code.

    ADD.
    Please Login or Register  to view this content.
    EDIT Code

    Please Login or Register  to view this content.
    maybe im missing something here i dont know.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,454

    Re: edit function on userform not functioning correctly

    Suggest you upload a sample workbook to allow the code to be tested.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    03-30-2015
    Location
    Northampton
    MS-Off Ver
    2010
    Posts
    275

    Re: edit function on userform not functioning correctly

    ****Solved**** it was not the code that was wrong it was me..

    i put a Sortit table as a rowsource and it apparently did not like so i took it out and now edit button works great.

+ 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. LOOP not functioning correctly
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2013, 02:03 PM
  2. networkdays not functioning correctly please help
    By jtmayo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-07-2012, 08:27 PM
  3. Why isn't this if statement functioning correctly?!?
    By rmar2011 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-29-2011, 07:31 AM
  4. LookUp Function Not Functioning Correctly
    By mycon73 in forum Excel General
    Replies: 3
    Last Post: 07-19-2011, 10:31 AM
  5. AutoComplete not functioning correctly
    By JCLSB in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2006, 03:30 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