OLAP to Reference ListBox (Active X Control)

jmrobinso2

New Member
Joined
Mar 15, 2018
Messages
1
I have =CUBEVALUE() functions referencing twenty Lists created with Data Validation (Bolded below).

=CUBEVALUE("ThisWorkbookDataModel",$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$E$2,$E$3,$E$4,$E$5,$H$2,$H$3,$H$4,$K$2,$K$3,$K$4,$K$5,$N$2,$N$3,$H$7,$A$1,$A12,B$11)

The limitation is that only one value per list can be selected.

Is there a way to get the =CUBEVALUE formula to reference a checkbox (List Box (Active X)) so that multiple values are referenced?

Example:
Current: $B$2 List - Select - Waldorf Astoria. Returns total Revenue for Waldorf Astoria
Desired: $B$2 Checkbox - Select - Waldorf Astoria, The Watergate Hotel, Beverly Hills Hilton. Returns sum total Revenue for those three hotels.

Thank you!
 

Forum statistics

Threads
1,086,122
Messages
5,387,975
Members
402,091
Latest member
thomastsiakis

Some videos you may like

This Week's Hot Topics

Top