Auto clear of the Month Selections

[#1]

Hi,

I have 2 tabs in my dashboard.In the both tabs i have month selection like Jan,feb,mar,apr..etc(list box).I used the same object on the both tabs called as "Month".

Now what i want is if one user navigating form tab1 to tab2, month selections in the tab should be clear.

Please advice how to achive this.I think this possible with maco.If anybody already implemented this post me the macro [:)]

Thanks in Advance.

Ram.

[#2]

One correction:

Now what i want is if one user navigating form tab1 to tab2, month selections in the tab2 should be clear

[#3]

Hi Ram,

here are an example.

SUB Clear
ActiveDocument.Fields("Year").Clear
'ActiveDocument.ClearAll true
END SUB

Rainer

[#4]

Thanks it's working for me