datevalue and languages

[NicolaasH]

Hi,
Situation:
I have build an elaborate spreadsheet which will be shared by several people. In this one can select a month (written out: January, February etc.)and a year from two validation lists. I have then used the DATEVALUE function to convert these parameters from the two cells into a date.
Challenge:
This worked fine on my computer which has English regional options and language selected. However on a Dutch configured computer the function returned a #VALUE! error, since it does not recognize the English month names. When calling the same method in VBA it also does not always work.
Question:
1. Is there a way of changing the settings in the Excel sheet which might solve this (without going into the Control Panel or using VLookup functions and the like)?
2. Would it be possible to change these settings automatically using VBA code?

Thanks!
P.S. I have also posted this message in the Excel forum if it is more appropriate there.

 

[SkipVought]

I posted an answer in Forum068.

Is this a VBA question or a Shreadsheet question?

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}