strEndDate = Format("01 " & cboMonth & " " & cboYear, "dd/mm/yy")

THIS CODE WORKS PERFECTLY, but returns 01/xx/xx
I need it to return xx/31/xx so the variable cboMonth should be first the day is set and I need a return of the variable year.

when I change the code to:

strEndDate = Format("01 " & cboMonth & " " & cboYear, "dd/mm/yy") or any combinations I get xxx xxxx
month and day together separtated by a 4 digit year when i need two. plus the "/" is completely gone. I think maybe its become a string or something; any ideas? I just need to swith cboMonth with the first string!!!