Hi all.
I thought I was being extremely clever when I created a set of dynamic text boxes on a form.
For i=1 to DynamicListCount
Set TextBox= FrmForm.Controls.Add("Forms.TextBox.1", "txtBox" & field.Value, True)
'setpositions, etc...etc
Next i
however, since it's dynamic, I can never know how many are created at runtime. They are labeled txtBoxABC1, txtBoxABC2,txtBoxABC3, etc in the loop.
How can I write a function that detects which of these textboxes is updated, and allows for subsequent processing?
I'm sure this is fairly simple (I can write individual functions but that would be dumb as there may be hundreds), but i don't know how to do this dynamically. Can anybody advise please, or point to a website with this info.
Cheers and Happy Easter!
Bookmarks