Hi,

I have a userform, with "TxtMonth" (for the MM/YY entry) and one OK
button.

I want to enter the JAN-08 in the textMonth and I want to see
the result in the sheet when I press Ok button.

I made the procedure for it, but it is showing 18-Jan-08 in the sheet,
which is wrong. I want to see 01/01/08 in the worksheet.

because I made the advance filter procedure it is detecting 01/01/08
when I type the JAN-08 in A2 cell in the worksheet, then it is
filtering by month.

pls send me the solution, if you have

Thanks in advance.

Syed Shahzad