Visual Basic query!!!

  • Thread starter Thread starter stedyeddyallsop
  • Start date Start date
S

stedyeddyallsop

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
 
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).Value


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





"stedyeddyallsop" <[email protected]>
wrote in message
news:[email protected]...
 
Use the Initialise event of the form :-

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