set a default value on textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
Back
Top