magic_orange
New Member
- Joined
- Jun 23, 2008
- Messages
- 8
Hi all, I'm a newbie to this board so please if you could, be gentle with me...
What I'm currently flummoxed with is how to loop through the text box controls on a user form one by one, find their particular names and then change the caption value on each one via another Excel workbook which I'm reading by ADO. The last bit is FYI but not pertinent - I simply want to know what the code is to loop through the controls on a form and when I've found the one(s) I want to set a value on them. Can anyone help? I'd make you a virtual cup of tea....
Cheers
Scott
What I'm currently flummoxed with is how to loop through the text box controls on a user form one by one, find their particular names and then change the caption value on each one via another Excel workbook which I'm reading by ADO. The last bit is FYI but not pertinent - I simply want to know what the code is to loop through the controls on a form and when I've found the one(s) I want to set a value on them. Can anyone help? I'd make you a virtual cup of tea....
Cheers
Scott