On 4 Lut, 13:46, Paul Schreiner <schreiner_p...@att.net> wrote: > 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.
Thx :) > 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... I'll try to explain: I've made something like calendar with labels - there is 3x colums (which representes days) and 12 rows (12 months). I need to know which one label was clicked - after clicking label, i'll get information which day user has selected. Then i'll be able to write code (autofilter of some sheets with date as criteria -> and then filtered information -> listbox in userform) There is about 450 labels on userform - i can't write separate click- events for all labels - it's insane. I got no idea how2 check which label was clicked - as i said, i've been trying to use ActiveControl.Name to identify name of label, but it doesn't work. It gives name of every control on my form, except labels :/ I've been thinking about using textboxes instead of labels, but it doesn't work as it should (entering to textbox after click) No idea as for now how to solve this problem Greetings :) ini --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
