+ Reply to Thread
Results 1 to 3 of 3

Thread: Help with Error '1004'

  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    66

    Help with Error '1004'

    Hi Ladies and Gentlemen,

    I am having trouble with a specific form in my spreadsheet. whenever I click the macro to open the form, I get Error '1004' Application defined or object defined error. All the other forms are working well, except for this one. Although the form, when exported to another sheet work fine.

    I am attaching the spreadsheet as well. To regenerate the problem, on the TEMPLATE page, click GENERATE NEW ISSUE DOCUMENT

    the form giving the problem, was discussed here http://www.excelforum.com/excel-prog...73#post2686973

    Thank you for all the help so far

    Jakes

    Issue slip Template v1.2.xlsm

  2. #2
    Forum Guru Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,276

    Re: Help with Error '1004'

    Hi Jakes,

    I'm not sure what you are trying to accomplish with
    Me.cboDrawings.List = .Resize(.Rows.Count - 1).Offset(1).Value
    Please leave a message after the beep!

  3. #3
    Registered User
    Join Date
    03-03-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: Help with Error '1004'

    Hi there,
    thank you for the quick reply.
    Well, I did not write the entire form, got help as on the link in the first post. But the form did work well until now. and I do not know what I did wrong?

+ 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.2.0