set a default value on textbox

D

Dave

I am trying to inialise a textbox with a cell value but I am getting the erro

"Invalid use of the poperty

defaultdate = Worksheets("Update").Range("A2"
UserForm1.TextBox1.Text (defaultdate

Any ideas?
 
B

Bob Phillips

Hi Dave,

Try

UserForm1.TextBox1.Text = Worksheets("Update").Range("A2").Value



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top