UserForm TextBox Date Format with Automatic Dashes

[saucey]

Hello, I have the following code:

Please Login or Register  to view this content.

I have this located behind a userform that takes in numerical values for a date textbox. This code helps to format it in the proper way I want it. However, I run into a problem when I enter a month that has a zero in front of it. For example 08-21-2012, is not recognized by this code.

Any Ideas?

Thanks,

Saucey

[john55]

try this

Please Login or Register  to view this content.

[saucey]

Hi John55,

Thanks for your reply, but your code gives me an 'Overflow' error. I've isolated the part of the code (my original and your proposed solution) in the attached Macro-Enabled Excel Document.

~Saucey

[john55]

I do not have that err

[saucey]

Hello John,

Thank you for your help, but I think it gives the user the error when he or she does not type dashes in between. I want to be able to make it where the user simply types in the numbers and the date is formatted correctly as a short date with dashes.

~Saucey

[john55]

I would use a calendar to force the user...

[DianneDB]

Hi Saucy,

I have used the following code in my userform, it works well for me:

Please Login or Register  to view this content.

[saucey]

@John

Dude you rock! Your calendar works great! Very user friendly! Did you make it? Or did you download it from somewhere?

FYI future readers: Make sure you transfer the appropriate modules and class modules over to your excel vbe

@DianneDB

Sorry, I didn't get your code to work :-(

[john55]

saucey, I am glad it works for you!
No, I did not make it, I saw many solutions here using this calendar! I am not sure who made it but it's great!

[puthireddy]

Hi John,

i am using your code to show the calendar but i am getting User-defined error when i ran the code. Could you please tell me how to define "Dim Buttons() As New clsCmdButton". I am getting an error here.

regards
Prathap

[john55]

hi puthireddy
and welcome!

please open your thread and ask for help right there!

[puthireddy]

Hi John,

Thanks for your response. I had created a Userform with few textboxes and i want to see a calender when the cursor goes to one of the textbox. I had used your code but i got an error saying "User defined error" for "DIm Button() as New clsCmdButton". I would like to check with you how i can generate this clsCmdButton. Because in your excel file it showing in propety window but it not showing in my excel file. Please help on this.


Regards
Prathap