Hi Dave,
This code is extremely useful, thank you for posting it. But I a
having one slight problem with it. When it copies the data back int
the sheet the formatting is all wrong and it is confusing when date
are displayed on the form in text format.
My columns are as follows:
1 - Text
2 - Text
3 - Date (dd/mm/yyyy)
4 - Date (dd/mm/yyyy)
5 - Currency ($#,#00.00)
6 - Currency ($#,#00.00)
Is there any way i can get this to update in the form and also on th
sheet - I have tried stepping through the code, but i can't work ou
where to put the format changes.
THANKYOU :
--
Sami8
-----------------------------------------------------------------------
Sami82's Profile:
http://www.excelforum.com/member.php...fo&userid=2711
View this thread:
http://www.excelforum.com/showthread.php?threadid=33594