Posted to microsoft.public.excel.programming
|
|
Dynamically populating textboxes on a form
For i = 1 to 5
FormName.Controls("txtReporter" & i).Value = String Value
Next i
--
Regards,
Tom Ogilvy
"Adamaths" wrote in
message ...
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
|