I have a user form, and am wanting to inset a cell of data into a text
box in the user form. This is information that will change each day,
and will also need to change the data for each day of entry. Please
help!!! e-mail my address, cheers, ed


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

If your data is in a column, with the latest data always at the
bottom of the column, use something like

Me.TextBox1.Text =
Worksheets(1).Cells(Rows.Count,"A").End(xlUp).Valu e


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"stedyeddyallsop"
wrote in message
...
I have a user form, and am wanting to inset a cell of data into
a text
box in the user form. This is information that will change
each day,
and will also need to change the data for each day of entry.
Please
help!!! e-mail my address, cheers, ed


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

Use the Initialise event of the form :-

Private Sub UserForm_Initialize()
TextBox1.Text = ActiveSheet.Range("A1").Value
End Su

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