Hello guys,
I am trying to figure out, how can I clear 7x Label at userform called Properties by for Loop,when I click at something at different userform for example UserForm1. I can overwrite Label alone, but this Loop gives me an error message and I dont know the right Syntax.
Every help would be welcome...For i = 1 To 7 Properties.Controls(Me("label" & i)).Caption = "" Next
Here is solution for some reason, me have to be out...For i = 1 To 7 Properties.Controls("label" & i).Caption = "" Next
TheOriginally Posted by petroj02
was wrongMe("label" & I)
'Me' would be the user form, and ("label" & I) would be the index into the Controls collection of the Properties userform
So that's why your solution worked
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Posting Permissions
Reply With Quote
