![]() Sorry for the long post but I hope it provides clarity to what I want to do. ![]() Worksheets("Overall").Cells(i, 3).Value=TextBox2.Text TextBox14.Text=Worksheets("Overall").Cells(i, 11).Value TextBox2.Text=Worksheets("Overall").Cells(i, 3).Value If Worksheets("Overall").Cells(i, 1).Value=Current_Status Then Lastrow=Worksheets("Overall").Cells(Rows.Count, 1).End(x1Up).Row Then when I add a date in TextBox14 and click the update button, those orders are updated. ![]() I cannot see the attached file because this computer does not have a full suite of Excel and the other is restricted for downloads.īelow is the VBA code I'm using and working perfectly. So instead of section CommandBox1 having only one search criteria, I want to have two and the ability to list up to ten orders (TextBox 2, 3, etc) that meet that criteria.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |