Hi I'm still learning Excel VBA and i need help with what I'm currently working - Calendar.
Environment: 64bit W7
Excel Version: 64bit
as we know, MS Date and Time picker is not available in the system i use so I had to create my own (and its hard). aside from its part of my learning, its helping me to familiarize myself with VBA. now here is the help i need:
I'd like to select a range of toggle buttons (Dates) if i clicked the Range command button in the date userform. letting the user to do it just by two clicks if they need to select long straight dates. unfortunately the office network doesn't allow access to any sites to upload an image of my work. but here are some details
42 toggle buttons (7 days x 6 weeks)
each toggle buttons are named as tglD1 - tglD42
let me know if you need more details.
Thanks in advanced!
Environment: 64bit W7
Excel Version: 64bit
as we know, MS Date and Time picker is not available in the system i use so I had to create my own (and its hard). aside from its part of my learning, its helping me to familiarize myself with VBA. now here is the help i need:
I'd like to select a range of toggle buttons (Dates) if i clicked the Range command button in the date userform. letting the user to do it just by two clicks if they need to select long straight dates. unfortunately the office network doesn't allow access to any sites to upload an image of my work. but here are some details
42 toggle buttons (7 days x 6 weeks)
each toggle buttons are named as tglD1 - tglD42
let me know if you need more details.
Thanks in advanced!