Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lulie Fischer   on Aug 29 In MS Office Category.

  
Question Answered By: Jenny Lopez   on Aug 29

Any "control arrays" you create  in VBA is going to have to be using text in
the name I think. Like "Control-01", "Control-02,.... And so on.

It's not all that difficult and if you writ a function/sub to process them
there is an overhead but not that much I think.

You could for example code...
subControls 1,"OK"

To set  the caption of control  cmdControl-1 to "OK".

Inside of the sub you'd loop around the controls  testing to see if the end
of the name is 1,2,3 whatever. You could add a control type or partial/full
name to that as well.

I agree though. It's a nice feature of VB to be able to create a control
array IMHO.

Share: