set a default value on textbox
 

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?

set a default value on textbox
 

UserForm1.TextBox1.Text = defaultdate


---
Message posted from http://www.ExcelForum.com/

set a default value on textbox
 

Dave

The proper syntax is:
UserForm1.TextBox1.Text=defaultdate

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Dave" skrev i en meddelelse
...
I am trying to inialise a textbox with a cell value but I am getting the
error

"Invalid use of the poperty"

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

Any ideas?

set a default value on textbox
 

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)

"Dave" wrote in message
...
I am trying to inialise a textbox with a cell value but I am getting the
error

"Invalid use of the poperty"

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

Any ideas?