Results 1 to 17 of 17

User Form closes prematurely

Threaded View

  1. #1
    Forum Contributor 00Able's Avatar
    Join Date
    11-17-2010
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    244

    User Form closes prematurely

    If you go to the worksheet PTO Log, and click on the submit entry the user form will appear, randomly select a name, put in the amount of hours, when you go to click a "start date", a pop up calendar will appear, once you select a date, both the calendar and the userform, will close, not recording any of the data.
    Here is the line of code that is giving me an issue:
    Unload Me
      Sheets("PTO LOG").Activate
    in both the frmPTOLog and frmPTODelete, the userform prematurely closes, without recording the data. If you take that code out of both forms, the userform works correctly.

    What I was trying to do, was to have the file go back to the Log worksheet after the information was recorded in the calendar.Any ideas?

    Also there is another issue, but I will address that in another thread...also for reference I am using 2010 excel, but this will be used in both 2007 and 2003.
    Attached Files Attached Files
    Last edited by 00Able; 02-24-2011 at 08:26 PM. Reason: Decided to Accept that it doesn't work on my environment thanks for all the input.
    Providing Problems for Your Solutions
    STARS are my Punching Bag, You will be rewarded.

    In the rare event that I may help you, feel free to make me see STARS

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.6.0 RC 1