User Form Names with numbers & Looping through them

LSanders · May 23rd, 2002, 08:01 AM

I have a User Form with text boxes and drop lists with similar names but with sequential numbers at the end (i.e., Name1, Name2, Name3).

I would like to create a loop in VBA that cycles through each name, using a FOR NEXT loop as the counter. How can you concatenate the "Name" and sequential number and use it to retrieve the information in the text box or drop list?

Mark O'Brien · May 23rd, 2002, 08:04 AM

Assuming they are called Name1, Name2 etc all the way up to Name10, this code will sequentially set the focus in each one. (Although this is a bad example since it will run too fast to see, but it gets the idea across.)



  For i = 1 To 10

    Me.Controls("Name" & 1).SetFocus

  Next

HTH.

May 23rd, 2002, 08:04 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Assuming they are called Name1, Name2 etc all the way up to Name10, this code will sequentially set the focus in each one. (Although this is a bad example since it will run too fast to see, but it gets the idea across.) For i = 1 To 10 Me.Controls("Name" & 1).SetFocus Next HTH. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 08:01 AM	#1
LSanders New Member Join Date: May 2002 Posts: 2	I have a User Form with text boxes and drop lists with similar names but with sequential numbers at the end (i.e., Name1, Name2, Name3). I would like to create a loop in VBA that cycles through each name, using a FOR NEXT loop as the counter. How can you concatenate the "Name" and sequential number and use it to retrieve the information in the text box or drop list?