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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Date to Last Day of Month 3
Firing Event in another user form 1
Userform textbox string to header causes unwanted double spacing 4
change controlsource for textbox depending on combobox selection 2
Highlight text in textbox 2
Delete enter key rectangles in a cell. 2
workbook used to open but now crash with File/path error 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top