Select a range of toggle button

nsguy_98

New Member
Joined
Sep 24, 2014
Messages
4
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!
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
So you want to create a Userform as a Date Picker and you have created 45 toggle buttons and now you want our help to do what?

Show us the scripting you have already written.
 
Upvote 0
Hi sorry i was busy for a while. Unfortunately i don't know where to start just for that range command button but i have already coded the rest of the calendar. if you don't mind, i can send you the file im working so you'll have the idea.
 
Upvote 0

Forum statistics

Threads
1,215,398
Messages
6,124,694
Members
449,179
Latest member
kfhw720

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top