Do while Loop - Form to Excel table

[Srikanth H N]

Hello there,

I am trying to create a do while loop for the below code on the user form. Not able to execute. In below code Textbox1 has date (i.e FROM Date) this works fine.
Now I have added another text box TextBox3 which will have (TO date). I want the do all the steps in the below code for each date i.e FROM date to TO date... eg if FROM date (TextBox1) is 07/01/2015 and To date (TextBox3) is 07/10/2015, i want the data to be copied from form to Excel table in 10 rows (each row for a single date).
Any thoughts on how loop can be applied for this.

Please Login or Register  to view this content.

Thanks!
H N S

[ranman256]

Please Login or Register  to view this content.

[Srikanth H N]

Thank you ranman for th equick assistance.
But when i execute the code provided by you getting an error message "Complie Error: NEXT wihtout FOR".