Actually, I thought your English was fine. In fact, I didn't even notice any problem until you said "I know it isn't QUITE good"... although it works, you probably should've used: "I know it isn't very good".. But you got the message across nicely.
Now to the question. You're clicking LABELS.? What code are you running that checks for a selected "label"? What fires off the code? Are you using a click-event for each label? I need a bit more information about your userform and the macro you're running... Paul ----- Original Message ---- > From: ini <inif...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Tuesday, February 3, 2009 11:15:38 AM > Subject: $$Excel-Macros$$ Userform & labels > > > Hi > I'm kinda new in VBA, and need to fix one problem, as for now i > couldn't find any working solution. > I got a lot of labels on userform, and need to know which one was > clicked. I've been trying to use > ActiveControl.Name .. but it gives a name of every control on > userform, except labels - when clicking on labels, nothing happen. > > Any ideas ? Anyone ? > Sry for my english, i know it isn't quite good. > > > Thank you in advance! > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---