User Form closes prematurely

[00Able]

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:

Please Login or Register  to view this content.

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.

[PY_]

It did not close for me until i submitted it. Once submitted, it then put the data in row 6.

[00Able]

So your saying it works properly for you, if so, can I ask what version of Excel you are using?

I am not sure why this is giving me issues, and need to gain some insight?

I don't see how this code could change anything that is related to how the date is submitted, but it quits everytime, I get to that point.

[PY_]

It worked fine in both 03' and 07' fo me. The Submitting and Deleting.

[00Able]

can you check my other post regarding this same form (attachment), and see what your results are?

[00Able]

Is it possible that by adding the code

Please Login or Register  to view this content.

, somehow in 2010 excel it is interpretting it as unload the userform?

[royUK]

Using the form allows the dates to be entered & the submit button works.

Y

[john55]

It worked fine in 07' fo me. The Submitting and Deleting.

[00Able]

Any ideas why my it wouldnt work in 2010?

[romperstomper]

Works for me in 2010.

[jaslake]

Hi 00Able

As you know, you and I have spent a significant amount of time on this project. At my suggestion (because your original thread was marked as "SOLVED"), you posted a new thread in order to get feedback from all the talent on the site and I've followed your new thread.

Here's my observations. I downloaded your attached file and WAS able to duplicate this consistently on the downloaded file

once you select a date, both the calendar and the userform, will close, not recording any of the data

I assumed you had modified some code SOMEWHERE that was causing the issue...so, I went through the code, line by line, comparing your code to what I'd provided.

Now, there's a lot of code...but, except for inconsequential differences, I could NOT find the problem. So, I saved your downloaded file to a new file "PTOCalendar11v12.xls". I ran the code in THAT file and it performed as expected. So, I'm thinking "What the heck is going on here". I closed the v12 file and re-opened the v11 file (your download). The code now runs as expected in the v11 file. I'm stumped.

I'm going to run more tests on the v12 file...if I can't break it, I'll upload it for your perusal. I don't have any clue what's going on.

PS:

Unload me

does just that

unload the userform

That's what the line of code is meant to do.

[broro183]

hi

00Able,
Based on John's comments of closing & reopening, you may find it helpful to run Rob Bovey's Code Cleaner addin (http://www.appspro.com/Utilities/CodeCleaner.htm) over your project.

John,
Sounds like you've done a fair bit of work on this, "comparing code line by line". Here's a link to some freeware that I find very useful for comparing vba code: http://www.formulasoft.com/vba-code-compare.html

hth
Rob

[jaslake]

Hi Rob

Actually, I used just that. Thanks.

The issue I've found with Code Cleaner is that it also removes any comment lines you've inserted for documentation. I've not used it for some time because of this. Has it changed?

[broro183]

hi John,

I'm not sure about earlier versions of CodeCleaner but version 5.0 allows you to leave the code comments. This can be done when you select your Project to clean on the "Projects" tab & then you decide what gets done by (un)ticking various nested options on the "Options" tab.
Do you ocassionally export & re-import modules manually, at some point in time, to ensure that any "invisible junk" is removed?

hth
Rob

[jaslake]

Hi Rob

I'm not certain what version of Code Cleaner I've used in the past as I've removed the utility because of my perceived limitations. I'll revisit it based on your comments.

Rob, I appreciate all the help you've given me the last several years. One doesn't get the opportunity to thank mentors personally...you've been one to me. Thank you.

[broro183]

hey John,

Thanks for the compliments
It works both ways - If you weren't the person you are, then I could be wasting some time when making suggestions BUT you are who you are, so Thank you

While I'm at it (turning the thread into a group hug!), there are 2 of my mentors here too - thanks RS & Roy

The way I see it, we're all learning - let's keep it up

Rob

[00Able]

John, all I did in this case is go back to the original thread and pull the file directly from your attachment, delete the previous items in the log, and enter in the "example" data, and then copy that one line of code, press save it and attach it to the post...

so the file is your file, nothing was changed except that one line of code...

Please Login or Register  to view this content.

I think it has to do with my environment...thats all I can think of.
Group Hug time:
I really appreciate all the time you have spent assisting me on this and other issues and hope your aware of the deepest gratitude that I have. One day I hope to be able to assist people like (all of) you do.

Please don't spend any more time beating this old cow, if this is working for everyone else...there is no point. It is primarily set up in the 2003 environment, so I am sure it will be fine. I just don't understand why it wouldn't work for my environment.

I am going to mark this as Solved, as I am comfortable with all the input given to this particular thread. Perhaps a quirk in 2010 has been found, hmmm or the 9th wonder of the world...lol