PDA

View Full Version : Solved: Looping with textboxes



YasserKhalil
06-25-2010, 02:21 PM
Hi everybody
I have a userform with five textboxes
I want a code that loops the textboxes to be like that

For I =1 to 5
Range("C" & I).Value=Textbox & I.Value
Next I
I'm not experienced at vba so I got errors
Please fix my faults

Bob Phillips
06-25-2010, 04:04 PM
For I =1 to 5
Range("C" & I).Value = Me.Controls("Textbox" & I).Text
Next I

YasserKhalil
06-26-2010, 03:41 AM
Thank you very much
It works perfect