Hi,

I have 2 Worksheet in my Excel report. On First Work Sheet (Sheet1)
I have list box fill up with Date values..On Work Sheet 2 I have Pivot Table.
Now I want to assign some selection Filter on Page field in Pivot table..

How Can I assign Selected value in list box ( on Sheet1) to Pivot table field
on ( Sheet2) for example..

List box : 10/1/2004,10/2/2004...etc
Now I will select in list box : 10/1/2004, This value I want to assing to
one field in Pivot table.. Let say EnterDt=10/1/2004 ( All the date in list
box is part of my dimensions)

Thanks