Index number for controls (eg Textbox) in userform

**asha3010** · 07-07-2010, 06:31 AM

Greetings,

Do userform controls have an index number that can be referred to in any code such that renaming the control will not impact the code?

Many thanks
Asha

**Cheeky Charlie** · 07-07-2010, 08:25 AM

They're 'indexed' in count form as they're added, but these aren't static, it you delete control 3 control 4 becomes control 3...

i.e. no, just get the names right

**Andy Pope** · 07-07-2010, 08:27 AM

the userform has a Controls collection that may be of use.

what exactly are you trying to do or avoid?

**davesexcel** · 07-07-2010, 08:29 AM

If you rename the Control, you will have to change the control name in the code.

**Cheeky Charlie** · 07-07-2010, 08:35 AM

Sorry asha, not exactly what you were looking for - but at least I'm not the only one not helping much! (with utmost respect)

They do have a 'tag' which can be used by (lazy) programmers to pass arguments between subs. (I do this, although I'm trying to shake the habit!).

So you could write code like:

Please Login or Register  to view this content.

I am, I'm afraid, not being entirely serious with this suggestion, but it fits...

**asha3010** · 07-07-2010, 08:37 AM

Thanks to all for your response.

Andy,

I am writing a code for updating a worksheet with the data in the userform. As an eg

Please Login or Register  to view this content.

So, if I change the name of any of the above controls, I will have to update the code. Am trying to minimise code maintenance, hence the question.

Let me know if I am not clear.

Thanks a lot
Asha

**asha3010** · 07-07-2010, 08:45 AM

@ Cheeky Charlie,

I have already tagged some of the controls for another purpose (formatting the display)!

Even if I remove the existing tags, I am not sure how to use your code for the purpose of updating a worksheet.....

Thanks a lot
Asha

**Andy Pope** · 07-07-2010, 08:46 AM

technically then you could do this

Please Login or Register  to view this content.

But I wouldn't.

I'm not sure how this fits into maintanence. If you are worried about the relevance of names for the controls do the design/thinking before rather than after.
Another impact of changing names afterwards is any event code will still require sorting out.