Visual Basic query!!!
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/ |
Visual Basic query!!!
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/ |
Visual Basic query!!!
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 |
All times are GMT +1. The time now is 03:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com