I came across a **working** dashboard example which was authored by "veekay". Please see attached XLS ("Dashboard"). The demo works great using the following process:
1. Click on command button "Update Drop Downs"
2. Select values from the combo boxes (Products, Region, Customer Type)
3. Click on command button "Show Data"
... given the selected cmd button values, data is shown in row 13++
For testing purposes, I mimiced the dashboard example (i.e., ensuring I copy all require objects and VBA code) before attempting to develop my own process (with different data).
Unfortunaly, when executing the "Show Data" command button (after "Updating Drop Down" and selecting values from "Products", "Region", and "Customer Type", I am getting run-time error '1004' (Methods 'Range' of object' _ Worksheet failed).
What causes this problem in my replicate XLS? Did I forget to update some VBA?
Thank you in advance,