Copy a Value from UserForm to cell

[stojko89]

Hi

I have a UserForm I'm using.
And I'm using this code for it:

Please Login or Register  to view this content.

And the part that bothers me is that values from txtDatumN and txtRokDob are sopose to be paste down as dates but are pasted down as text looking like a date. I have the cells where these 2 values get copyed in set as cells that are Dates.
So what I'm asking here is how can I make it past down not as a text but as a date?
Becose if it's passed down as a date the codittional formatting of the cells doesn't work.

[Domski]

Hi,

Use DateValue rather than Format as the latter will always return a text string.

Dom

[stojko89]

Thanks Domski that was easy and it works. :D