Userform with Time Field displays Time as Number

I have a userform that has a time field on it and then the userform displays the time as a number.

Ex. I entered 11:00 AM in the Time of Contact field and the form displays it as 0.458333333333333.

Below is the code that I currently have.

Please Login or Register  to view this content.

I am not sure how to change the code to reflect the time instead of a number. I am thinking that it needs to be formated somehow.

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Hi,

I think this is thread at issue

http://www.mrexcel.com/forum/showthread.php?t=360979

In fairness, the code was the same, but the question was different.

RoyUK has a date-picker add-in that avoids the need for other people to install calendar control:
http://www.excel-it.com/free_addins.htm

Leith,

Thank you! It worked perfect.



Charles and VBA Noob,

That posting is referring to using the Date & Time Picker for the DateofContact field on a Userform.

This current posting is referring to using a textbox for the Time Field.

I do realize they are very similar. I found out that the users would not have the Date & Time Picker so I would have to go with Text Box unless I could write the Date and Time Picker into code.

Sorry about any confusion that this may have caused.

If this is really cross posting please let me know and I will not post anything similar anywhere else.

shg,

Thank you. I will look at that add in. Do you know if after I create the file will the users need to install the add-in? I am not sure how to use this on the userform or how to write the code for it?

If it works should I post the solution on the other link or what do I do? I do not want to make a mess of this.

I am sorry that I am a pain I am a noob to programming and trying to learn as quick as I can.

Do you know if after I create the file will the users need to install the add-in? I

Yes, other users would need to install it. Had Roy provided the source, you could have copied the form and code to your workbook, but the project is protected.

You might Googleexcel date picker; I'm sure someone has posted an open-source version.

There's a calendar form to use in your projects here

The code in the addin is protected because it represents hours of work & I use it in many of my projects.