Given a User Form with 256 textboxes - how can I access a selected one?

[joebbb]

I have an Excel Form based application I am working on and one of the User Forms has 256 Text boxes (named T1, T2 . . . T256). I would like to be able to write a subroutine with 1 calling argument (a value 1 – 256) and have the subroutine set the background color of the selected text box. I know I can do this with 256 if..then statements but there must be a more efficient way to do this. Thank You

[Andy Pope]

You can use the controls object of the form to reference controls by name.
You can incorporate the following example in to a routine

Please Login or Register  to view this content.