Hello everyone, hoping I can get some help please! I haven't posted for some time but I am reasonable familiar with excel but I am stuck on this one!!
I want to create a Userform with 4 Text Boxes that simply pick out key column data from a dynamic row depending on the date in column A. Think of it as a summary Userform that just displays key information so the user doesn't have to scroll through lots of columns to pick out the data.
For ease I would like to load TB01 with Col B, TB02 with Col C, TB03 with Col D and TB04 with Col E.
The Userform should open when a button is clicked on the worksheet. Once clicked, all the text boxes should initialize with the data from the row that contains the earliest date in column A. The userform should have two buttons; one to load the data from the row of the next earliest date and one to go back to the previous row that was viewed.
The catch is that I only want to be able to scroll through all the dates that are in the past and no more than 10 days into the future. I dont have the need to view the summary details of anything outside of 10 days from todays date.
Column A may not be in ascending/descending date order so I need the userform to be able to collate and scroll through the data.
I can achieve it if I create an extra column and perform a RANK calculation but ideally I want to perform it all in VBA.
Thanks in advance
I want to create a Userform with 4 Text Boxes that simply pick out key column data from a dynamic row depending on the date in column A. Think of it as a summary Userform that just displays key information so the user doesn't have to scroll through lots of columns to pick out the data.
For ease I would like to load TB01 with Col B, TB02 with Col C, TB03 with Col D and TB04 with Col E.
The Userform should open when a button is clicked on the worksheet. Once clicked, all the text boxes should initialize with the data from the row that contains the earliest date in column A. The userform should have two buttons; one to load the data from the row of the next earliest date and one to go back to the previous row that was viewed.
The catch is that I only want to be able to scroll through all the dates that are in the past and no more than 10 days into the future. I dont have the need to view the summary details of anything outside of 10 days from todays date.
Column A may not be in ascending/descending date order so I need the userform to be able to collate and scroll through the data.
I can achieve it if I create an extra column and perform a RANK calculation but ideally I want to perform it all in VBA.
Thanks in advance
