Converting a String to a Numeric Date

How is the date being entered? In a cell, input box, user form? Though you mention"initialize", we don't want to make assumption about the data entry method.

You might consider using the pop up calendar control for users to select the date. This would help insure a valid date is always entered.

Its a user form, just an input box. I used this line in the Initalize function:

Please Login or Register  to view this content.

Perhaps this isn't doing what I thought it would? That is create the variable as a "Date" type?

Create a new user form and put the calendar control object in it. You may need to rifght click the control toolbox and choose "additional controls" to find and add the Calendar Control.

Drag and size the calendar control onto the new form.
Double click the form and modify this code.
(I assume you are entering the date into a text box. If so, set the text box entry even to show the calendar form.)
For the activate event:

Please Login or Register  to view this content.

Calendar Click Event

Please Login or Register  to view this content.

If entering the date into a cell, the modify this:

Please Login or Register  to view this content.

Use this to get the date into the worksheet:

Please Login or Register  to view this content.

Trying a few differnt things now. The only calander control item I can locate in my version is for MS Office Project, and it doesn't behave the same as what you are describing above.

So I tried to use the UserForm_Activate() sub to initalize my already existing entry box value as a date, and that worked.

However, I keep getting type mismatch errors when I attempt to compare the date to a date in the spreadsheet. All I am doing is trying to compare to see if the user's entered date is larger than the begining of each week, in an attempt to locate which week I need to input data. I would assume that they need to be in numeric format to do this.

Does VB not treat a "Date" similarly to excel, and automatlcy treat it as a number when you execute a comparison?
Can you offer any advice on this?

Wow... I can tell its been a while since I wrote code this much....

I had a variable declared as CompDate, and then later when I tested it I used DateComp

<*blush*>

Let me see if this fixes the problem....

CDate() is exactly what I needed. Seems to be working now. Thanks!

Invalid date entries is common. I was only attempting to point you to a solution that provides a method of entering a valid date, but should have just provided the code given by shg. Sorry if overwhelmed you.

No problem Palmetto, your advise was helpfull as well. Thanks!