View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Userform Controls

Thanks, most helpful.

--
Cheers
Nigel



"Tushar Mehta" wrote in message
...
To answer your specific question, you could use Controls("X" & i).

You may also find John Walkenbach's object-oriented solution useful. See
Handle Multiple UserForm Buttons With One Subroutine
http://j-walk.com/ss/excel/tips/tip44.htm

"Nigel" wrote:

Hi All
I have a set of controls on a userform, named x1, x2, x3 ........... xn

etc

Is there a way of setting these controls in a loop eg

for i = 1 to n
set control x of i to something
next i

I am not sure how to point to a named control by constructing a string

for
the name? Help!

--
Cheers
Nigel