While running a Case, why can't I use the following instruction:
VB Code:
Printable View
While running a Case, why can't I use the following instruction:
VB Code:
I assume this is a continuation of your previous post?
I don't have any experience with pivot tables, but maybe your problem is due to the use of cbo1Selection, which is defined within a change event procedure for your combobox and you are trying to call it from another procedure.
If the above is correct you will be getting a "variable not defined" error.