Results 1 to 10 of 10

Code producing error, only on third run of Userform...?

Threaded View

  1. #1
    Registered User
    Join Date
    08-27-2009
    Location
    Milton Keynes
    MS-Off Ver
    Excel 2007
    Posts
    45

    Code producing error, only on third run of Userform...?

    I have created a Userform with various Listboxes, some interacting with others.

    I'm currently getting a rather frustrating error that decides to only show up on the third run of the UserForm.

    It will work perfectly fine with two runs of the Form (as in open, close then reopen) however, on the third attempt it will throw up an error (as attached) and will continue to do this for three runs of the Form and will work on the fourth.

    I'm not changing any piece of code within these runs, I don't understand why it works one minute and not the next...

    As mentioned, I have attached an image of the issue I'm having. Hopefully this provides enough info...

    Thanks for your time.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code not producing a value
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-29-2013, 12:40 PM
  2. [SOLVED] Can't debug this code. The Arrays are producing a Subscript out of Range error
    By seigna in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-06-2013, 05:14 PM
  3. [SOLVED] Dount VBA code producing Run-time error '3075'
    By jeskit in forum Access Programming / VBA / Macros
    Replies: 13
    Last Post: 07-16-2012, 07:25 AM
  4. UserForm Code Error
    By Mooseman60 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2010, 09:05 AM
  5. VBA code suddleny producing an error
    By drgogo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2010, 07:18 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