Why the For... Next doesn't take value from 100 to 299?

[gulong]

I created a For...Next loop that takes values from three VBA textbox. ex:

For i = Starting.Text To Ending.text Step q.text

If ... Then V.Text = i
....
next i

It works from 1 to 99, but doesn't work from 100 to 199, works again from 200 to 999, but doesn't work from 1000. Can anybody share a light on this? Thank you very much. (The values are Ending.text, with step q.text being 1.)

 

[genomon]

Make sure you are getting numbers and not strings from the text boxes; Check out help on CStr(), CInt(), CSng, and CLng() functions....

 

[cc5305]

Also you really don't need the part of 'Step q.text' part if your increment for each loop is 1. VB defaults the step to 1 even if you don't declare it at the for loop statement.