Hi,

Is there anyway I can auto populate a set of similarly named textboxes
on a user form.

For example, if I have textboxes named txtReporter1 to txtReporter5 I
want to run some code along the lines of:

For i = 1 to 5

FormName.txtReporter & i.Caption = String Value

Next i

The textboxes already exist on the form and are blank but need to
populated differently depending on how a user has accessed the form.

As always, any help is greatly appreciated.

Kind Regards,

Adam


--
Adamaths
------------------------------------------------------------------------
Adamaths's Profile: http://www.excelforum.com/member.php...o&userid=31580
View this thread: http://www.excelforum.com/showthread...hreadid=512806