sorry to sound completely newb but hay,

i have this code (not all of it but to the point)

"indate" is a textbox in the userform

Private Sub UserForm_Activate()
datein = Sheets("sheet1").Range("a2")

indate.Text = datein

End Sub


where do i put your code ????
if i place it anywhere in this code it errors ????


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=560575