result formula cell is doubled in result cell

[littlepete]

hello

I did and still do learn a lot and I love that !!! I love VBA ...
but because i'm just basic, i often do not understand reasons why something goes wrong...

what I hate, is that something goes right the whole time, and then without having done anything with it,
it changed into an error :

look at the joined picture: column T gives the date of baptizing. column U reforms it to mmdd and adding number 2 (for baptize)
you can see the formula for column U in the top formula bar, and the result in cell U6 ...

why did the result double itself from " 20.05.1961 " to : " 20.05.196120.05.19612 " ? it should be " 05202" !

mysterie...

 

[littlepete]

thank you for all your replies but they are not funny and really not helping.

this is what i have:

the line to copy data from textBOX to cell in database:
Sheets("gegevens").Range("l" & dezerij).Value = ufpersonenfiche.pftitel.Text

the textbox contains a string. the cell in the database is a date cell " dd.mm.jjjj"

now what happens?
if i execute the above line the result in the cell is NOT a date (forex: "15.02.2000") but two times that value: "15.02.200015.02.2000"
when i change the line to :
cdate(Sheets("gegevens").Range("l" & dezerij).Value = ufpersonenfiche.pftitel.Text)
then i get an error saying the values are not compatible

when i add format to that :
format(cdate(Sheets("gegevens").Range("l" & dezerij).Value = ufpersonenfiche.pftitel.Text))
i get the same error

so my question is: how do i copy the string of a date into a data-formatted cell ???

thank you...

 

[RoryA]

thank you for all your replies but they are not funny and really not helping.

Same goes for you, as you still haven’t actually answered my question. Until you do, I can’t help you.

 

[littlepete]

you asked what the problem was and i just answered with all possible details.
so dont bother and leave me alone.