How to click buttons though loop.
Hi I have a scenarion in which i have 40 buttons on a from and instead of clicking every button one by one i want click these buttons through loop, can any body tell me how can i click these button...
Forum Discussion
I might place the object names in an array.
sObjName = "Name1|Name2|Name3|Name4"
asObjName = Split(sObjName, "|")
Then you can loop through the array
For i = 0 to UBound(asObjName)
set obj = something.VBObject(asObjName(i))
obj.Click
Next
I have not tried this, but if I wanted to do this, I would bark up this tree to start.
sObjName = "Name1|Name2|Name3|Name4"
asObjName = Split(sObjName, "|")
Then you can loop through the array
For i = 0 to UBound(asObjName)
set obj = something.VBObject(asObjName(i))
obj.Click
Next
I have not tried this, but if I wanted to do this, I would bark up this tree to start.