Loop for text box data in USER FORM

[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.

When I tried to use While loop getting an error message: “Compile Error: NEXT without For”

Below is the code.

Please Login or Register  to view this content.

Thanks!
H N S

[Kaper]

You got this error message because you used

Please Login or Register  to view this content.

while you shall use

Please Login or Register  to view this content.

[Srikanth H N]

Thank you Kaper.

Though the macro is working when changed to "Wend" from "Next".
Not able to get the desired output... eg. if I input in TextBox1 as 07/01/2015 and in TextBox3 as 07/02/2015... I wanted just 2 rows of data to be pasted in sheet i.e 1 row as 07/01/2015 and the 2nd row as 07/02/2015.
But the macro is pasting the single date 07/01/2015 for 29 rows...

Any thoughts. I know I am asking too much Sir, but have struck in this from past 40+ hours.

[Kaper]

No file so I not played with it.

Looking at the code I have no idea what is assigned to:

Please Login or Register  to view this content.

or to

Please Login or Register  to view this content.

and how dates could be written into a sheet while your date is stored in

Please Login or Register  to view this content.

but it is never used in any of

Please Login or Register  to view this content.

assignments

so blind guess assuming your declaration that from/to dates atre in textbox1 and 3:

Please Login or Register  to view this content.

[Srikanth H N]

Many Thanks kaper. Based on you r inputs twiked code a bit and it works perfect!!!