Textbox problem in Userform
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
|