ERROR Handling on Pivot Table with Combo box workaround

Hi, I am currently using this code to return a message warning that the values for the current month are not yet available, when you select the month through a Combo Box... The reason I connected to Combo box as a Pivot Page field for "Month" is because people could choose "All" to show the months, which is wrong! The months should be chosen one by one, because the value is already accumulated from e.g. 1-8 (Jan-Aug).

Please Login or Register  to view this content.

Thanks in advance!

Rafa

I forgot to point out the problem... So here it goes:

I have only the data from October(10), but in the Combo box you can already choose for November and Dezember (11, 12). When I select them the error msg box prompts..Works fine! But when I go back to October it should not be prompted again, once the data exist...

Thanks again