Access Dynamic Labels in Userform Class Events in Excel VBA

[aprasad]

i have one tabstrip with varying tabs. Each tab will have 3 dynamic labels. I have added dynamic labels with identical names corresponding to tab number and label number like "tsTab_lblNo" & x & "_" & n making visibility FALSE. Then added to existing mButtons public collection. Here I like to display the corresponding labels when clicked on a tab item. i understood tabstrip wont store controls. i tried in different ways but could not succeeded. Please help.
Code is as follows. My tabs label code in module

Please Login or Register  to view this content.

Class event code

Please Login or Register  to view this content.

[rorya]

Then added to existing mButtons public collection.

No, you didn't. You added them to a local variable which is reset as soon as your routine ends.

[aprasad]

Thank you Mr Rorya for your early reply. Sorry, i have not mentioned here but I have declared mButtons as New collection and ts_label As MSForms.Label only. Error is at line Controls("tsTab_lblNo" & Mytabstrip.Value & "_" & n).Visible = True in class Mytabstrip_Click(ByVal Index As Long) event, saying sub or function not defined. If possible please correct code

[Norie]

You've declared mButtons within the sub test, as soon as that code stops running mButtons will be out of scope.

[rorya]

You also need to refer to mytabstrip.Controls since your class does not have a Controls property.

[aprasad]

Mr Norie and Rorya, Infact mButtons is declared as public variable in calling procedure Public mButtons As New Collection. Also I have tried with Mytabstrip.Controls("tsTab_lblNo" & Mytabstrip.Value & "_" & n).Visible = True in class code. But no result.
1. Am I referring label in Collection correctly as Controls("tsTab_lblNo" & Mytabstrip.Value & "_" & n) ??
2. Can one collection mButtons, be used for both buttons and labels ?

Please guide

[Norie]

If you've already declared it publicly why are you declaring it again in 'test'?

[aprasad]

I will use it when running in current module, otherwise i will make it comment. just to understand. In addition to my earlier mentioned doubts, one more cropped up. will labels can be accessed by its name? If can't, can i get same display sequence with text boxes and how?

[rorya]

Any control can be accessed by name.

[aprasad]

ok, noted. For easy understanding my problem, i have uploaded my sample excel file. Please suggest the changes.

[aprasad]

PS: project starts from Userform1.

[aprasad]

I expect problem is in referring mButtons collection or Controls in class events. I could not figure it out the syntax. Being a public variable mButtons collection is storing controls as required.
May be the labels created are not linked with userform object. In local window of module code, label controls are visible, but when moved to class events (with userform Me) neither controls collection nor the added labels identified.
Hope this makes my problem more understandable.

[rorya]

Since you added the three labels to the userform, you'd need to refer to them in your tabstrip class handler using:

Please Login or Register  to view this content.

That will only work for the first 'page' of your tabstrip since you only have three labels.

[aprasad]

Thank you rorya. seems working, labels are behind the tabstrip, so need to do more. Can you say the reason to spell parent, 3 times? I have declared ctrl as object and retrieved labels from mButtons collection. But your single line code, looks more interesting. Please explain. Also how to bring front labels. Thank once again

[aprasad]

I have tried with zorder(0). But not success. I could not understand when default value of zorder for any control is 0, why it is being displayed backward showing? I think latest object will have 0 automatically. waiting for your guidance

[aprasad]

I have tried with textbox control also, but both labels and text boxes are hiding behind either multipage or tabstrip. How to make label/textbox bring front when tab1 clicked? please help

[rorya]

You need to add the controls to the relevant container. For example, if you want the labels on a page of your multiframe, you should add them to that, not to the userform itself. You'll then need to amend the code I posted - the only reason it uses Parent three times is to get a reference back to the actual userform.

[aprasad]

Rorya, I have 3 labels/ textboxes for each Tabs( 5 tabs) of Tabstrip. On clicking of each tab, respective labels/texts should be displayed. I understood your suggestion. But could not able to implement. Error is 'object does not support this property/method". So again requesting for your correction. part of the module code is as follows.

Please Login or Register  to view this content.

[aprasad]

rorya, somehere i read that tabstrip is not a container, if true, is it requires to define a frame to contain labels/textboxes? else where i am doing wrong in declaring labels/textboxes? Pl suggest code

[rorya]

A tabstrip is not a container (I've always viewed them as more trouble than they're worth for precisely that reason). Therefore any controls need to be added to whatever contains the tabstrip - in your case that is a page of your multipage control, so that is where the controls need to be added.

[aprasad]

Sorry for delaying response. Thank you for your valuable suggestion and putting my code on track. I am obliged to thank you, Andy and Excelforum for my progress in my project.