Control arrays in VBA

[chrishooper]

Hi there,

I need to create multiple controls utilising the same subroutines in excel. After much web searching and head scratching i see that control arrays have been disabled in VBA. Can anyone help me to devise an alternative strategy to solve my problem? I am a very inexperienced programmer and need help

 

[oharab]

I use the Tag property of the controls (In Access, I've never tried in Excel)

Add a word or phrase to each tag of the control you want to identify.

Then do:

Dim ctl as Control
for each ctl in me.controls
if instr(ctl.tag,"Group1&quot>0 then
'Do Code Here
end if
next ctl


I use instr so i can have multiple tags on a control.

HTH

Ben ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[chrishooper]

Ben will i be able to add an indeterminate number of new controls at runtime and still use this method?

 

[chrishooper]

also, how does one trigger the routine you have included? I must be able to do it when any of the included controls are selected.