+ Reply to Thread
Results 1 to 5 of 5

Code error: Wont submit data from userform to seperate sheet and new line

  1. 02-07-2014, 08:30 AM #1
    mwinter
    mwinter is offline
    Registered User
    Join Date
    12-16-2013
    Location
    London, England
    MS-Off Ver
    MSO 2010
    Posts
    52

    Code error: Wont submit data from userform to seperate sheet and new line

    The below code should copy the details from my user form to the next available row on a seperate sheet, it currently is not coming working, it is not coming up with an error but also not working, can anyone spot the problem.


    ------------------------


    Please Login or Register  to view this content.
    Last edited by mwinter; 02-07-2014 at 08:35 AM. Reason: Forum Moderator
    Reply With QuoteRegister To Reply
  2. 02-07-2014, 08:39 AM #2
    mwinter
    mwinter is offline
    Registered User
    Join Date
    12-16-2013
    Location
    London, England
    MS-Off Ver
    MSO 2010
    Posts
    52

    Re: Error in code: HELP

    I fixed the formatting problems.
    Reply With QuoteRegister To Reply
  3. 02-07-2014, 09:10 AM #3
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Code error: Wont submit data from userform to seperate sheet and new line

    How are you calling this code?
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  4. 02-07-2014, 09:59 AM #4
    mwinter
    mwinter is offline
    Registered User
    Join Date
    12-16-2013
    Location
    London, England
    MS-Off Ver
    MSO 2010
    Posts
    52

    Re: Code error: Wont submit data from userform to seperate sheet and new line

    Im not sure i understand?
    Reply With QuoteRegister To Reply
  5. 02-07-2014, 10:11 AM #5
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    How is the code being run?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with VBA Code...error = run time error 1004 autofilter method of range class failed
    By Dariusd7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-15-2013, 05:03 PM
  2. VBA Code...error = run time error 1004 autofilter method of range class failed
    By Dariusd7 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-15-2013, 04:49 PM
  3. [SOLVED] Getting Error 1004 Object or Application Defined Error - Code to rearrange data
    By BlazzedTroll in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-10-2013, 12:10 PM
  4. [SOLVED] Range error in code, runs alone but not inside my full program, giving runtime error 1004
    By charizzardd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2012, 03:34 PM
  5. Error 424 Object Required Error when Using AddItem to ListBox Generated in Code
    By jclark419 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2010, 12:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1