Results 1 to 15 of 15

Userform Code Errors (broken by novice/fool)

Threaded View

D.A.S Userform Code Errors (broken... 11-22-2013, 03:05 PM
Leith Ross Re: Userform Code Errors... 11-22-2013, 04:41 PM
D.A.S Re: Userform Code Errors... 11-22-2013, 05:01 PM
Leith Ross Re: Userform Code Errors... 11-22-2013, 05:18 PM
D.A.S Re: Userform Code Errors... 11-22-2013, 05:45 PM
Leith Ross Re: Userform Code Errors... 11-22-2013, 06:23 PM
D.A.S Re: Userform Code Errors... 11-22-2013, 06:51 PM
D.A.S Re: Userform Code Errors... 11-22-2013, 07:00 PM
Leith Ross Re: Userform Code Errors... 11-22-2013, 06:54 PM
Leith Ross Re: Userform Code Errors... 11-22-2013, 07:06 PM
D.A.S Re: Userform Code Errors... 11-22-2013, 07:07 PM
Leith Ross Re: Userform Code Errors... 11-22-2013, 07:10 PM
D.A.S Re: Userform Code Errors... 11-22-2013, 08:27 PM
D.A.S Re: Userform Code Errors... 11-25-2013, 09:53 PM
Leith Ross Re: Userform Code Errors... 11-25-2013, 10:11 PM
  1. #1
    Registered User
    Join Date
    11-21-2013
    Location
    Wellington, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    20

    Userform Code Errors (broken by novice/fool)

    Hi All,

    Have only been using VBA for about a month and in all honesty most of the time I am completely lost and muddle my way through by trial and error looking at all the forum posts and add, alter, copy and delete code to suit (often in error due to ignorance). Unfortunately I am one of those people that decides to learn something new and jumps in with both feet and a complete lack of knowledge about what they are doing ... on the plus side, you guys get to show people like me the knowledge to strive for !

    Long story short, I created the attached workbook with a Userform to add new records and view and update existing records. Initially it worked fine and on opening with the "Update Records" button it would open the Userform with blank fields and on clicking the spin button would go to the first (or last) record which could then be updated. Unfortunately now however, I have done something to the code that effectively leaves the Userform broken. Ideally it would jump to the first saved record when opening and the add, update buttons etc would all work as intended, now they don't.

    If anyone knows how to fix the attached would be very much appreciated ... even better if you could tell me what I did wrong !

    Thanks for taking the time to read !
    Attached Files Attached Files
    Last edited by D.A.S; 11-22-2013 at 03:51 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Created a userform in VBA that worked beautifully yesterday and crashed Excel today!
    By willneal in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-31-2012, 11:47 AM
  2. [SOLVED] Average hours worked based on days worked during a pay cycle
    By jaycee66 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2012, 06:27 PM
  3. Replies: 0
    Last Post: 05-14-2012, 05:36 PM
  4. Calculating basic hours worked, between a time range and premium hours worked
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-07-2012, 06:59 AM
  5. Replies: 0
    Last Post: 01-05-2012, 06:23 AM

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