Hi everybody!

My problem is like this :

There is an Excel 2007 under Windows 7 (Version Home Premium, if it can be somehow helpful) file, including a worksheet with a region consisting of two adjacent columns. The left column A is supposed to contain some date values in European format (f.ex. "31.12.2006"), the right one (column B) contains some positive integers in standard formats.
Further, there is another cell (say 'AB1') with a formula "=MAX(B:B)", and one more cell (say 'AC1') with formula "=INDEX(A:A;MATCH(AB1;B:B;0))".
As long as I fill the data in the region 'A:B' manually, the both AB1 and AC1 display obediently what I hope to find there. For instance, if the highest integer from the column 'B:B' is 39000 while the corresponding date reads 11.01.2005, the value of the AB1 is 39000, and the AC1 shows 38667 (the date value from "11.11.2005").

If only I try to enter the same data pair using some user forms with two fields - for the date and for the integer, they appear properly in their designed positions in the array 'A:B'. The AB1 displays correctly the value 39000 (which is currently the real MAX(B:B)), however the AC1 reads now "11.11.2005" - though I need 38667 at this place.

What could cause this phenomen?

Any kindly advice would be highly appreciated.