Hi Dave,

Brilliant, many thanks for your knowledge and expertise. A big STAR. I am now
into final testing and can now finish the program on time.

Vic

ViViC


Dave Peterson wrote:
Ps. You won't want want to use General for dates.

with DestCell.Offset(0, 0)
.numberformat = "mm/dd/yyyy"
.Value = cdate(Me.Controls("textbox" & 1).value)
end with

This portion:

[quoted text clipped - 164 lines]

Dave Peterson


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200902/1