For loop for define command button task

Originally Posted by JohnTopley

Please post a sample file: instruction in yellow banner at top of the page.

1- Press Alt+F11 go to UserForm1. I want to summarize the entire code in a For loop.

2- In the main Form (open by click on "click" button in the middle) by clicking on TexBox From in top and left corner, only the rows of the table in DATA sheet whose values of the DateOfSet column (F) are greater than or equal to TextBox are displayed instantly.

I designed TextBox To and I try to write code for the upper limit but I can't able to do it. If the user started to enter value in From, the rows with a greater or equal value in F column will be shown in the ListBox. I want if entered a value in To, the rows with lower or equal value in F column will be displayed in ListBox, and if both are filled, rows with numbers (in F column) between the two will be displayed But instantly. That's all the difficulty of this issue.

3- (Plotting) I want when user enter the year value (in the chart section bottom right of Form) and enter value from and to and pressing the plot2 button, a bar chart will be displayed in a POP UP, each bar of which is the total number of Products in column C for each contractor (list of all contractor in A column in Peymankar sheet) in that year. (Year = First four numbers correspond to the value of column F).

Also file is attached in first post.

it's should be mentioned that in this post this problem is solved for situation that From and To in top corner of main Form, is of type date and because of I use Shamsi date , I can't use that. Because of this, I have to consider textboxs From and To are of number format.