paradox34690
04-15-2013, 11:27 PM
Hi everyone!
I'm working on some Excel VBA right now and need to determine what the first and last values of a selected Slicers range are.
Example (and this is pretty much my exact case):
Slicer - "Date"
Contains all dates as MM/DD/YYYY
If a user selects one, and then shift-clicks another value to create a range of dates (let's say 03/01/2013 is the first date, 03/15/2013 is the second) How can I determine what those first and second selected values are and assign them to 2 variables?
This is specifically what I need as I then need to work with a SQL table to do other calculations from those 2 variables.
Any thoughts? :dunno
I'm working on some Excel VBA right now and need to determine what the first and last values of a selected Slicers range are.
Example (and this is pretty much my exact case):
Slicer - "Date"
Contains all dates as MM/DD/YYYY
If a user selects one, and then shift-clicks another value to create a range of dates (let's say 03/01/2013 is the first date, 03/15/2013 is the second) How can I determine what those first and second selected values are and assign them to 2 variables?
This is specifically what I need as I then need to work with a SQL table to do other calculations from those 2 variables.
Any thoughts? :dunno