apen
06-06-2008, 08:56 PM
Hi all,:(
I have re-attached a file in which I still could not solve my problem -
the date display in the Combobox2 and Combobox3 not in format " dd-mm-yy" but instead of a value in the userform2.
If I change the Combobox to Listbox, then the format of date can display " dd-mm-yy" that I wanted. However, the datevalue could not be stored in the worksheets( "Attendance") if I pressed the cmdbutton (" confirm") in the userform2.
Could any expert point out my VBA where is wrong or missing, or how to re-write it.
I have re-attached a file in which I still could not solve my problem -
the date display in the Combobox2 and Combobox3 not in format " dd-mm-yy" but instead of a value in the userform2.
If I change the Combobox to Listbox, then the format of date can display " dd-mm-yy" that I wanted. However, the datevalue could not be stored in the worksheets( "Attendance") if I pressed the cmdbutton (" confirm") in the userform2.
Could any expert point out my VBA where is wrong or missing, or how to re-write it.