Is this what you want?
'Put the value of A1 in TextBox1 on UserForm1
UserForm1.TextBox1.Text = Range("A1")
'Open Userform1
UserForm1.Show
--
Ronald Ferdinandus
http://www.ro-pay.nl
"Matilda" wrote:
I want to use a date input into an input box. Every syntax combination I try
refused by compiler. Help please?