Userform listbox formatting on the fields of date

[carlrubber]

Would anyone help for formatting the userform listbox on the fields of date (Employment, First Completion, Last Review, Due and target completion, actually some calculation are behind) such that showing dd/mm/yyyy? even i force the input textbox in format of dd/mm/yyyy, it shown in the listbox again in the format of yyyy/mm/dd…? other than inputbox, I m happy on adding calendar form besides?
And how could i fix the first row about the column header in the listbox?
thanks in advance

[LJMetzger]

Hi carlrubber,

The following code snippet should help you format your dates any way you want:

Please Login or Register  to view this content.

And how could i fix the first row about the column header in the listbox?

I do not understand this question. The ListBox header looks OK to me.

---------------------
It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

I hope this helps.

Lewis

[carlrubber]

Thz for your reply. but i insert the code you suggested and i add an entry from blank form, the result shown in listbox do not as expected as dd/mm/yyyy………
for the second qs, if I have entry more than the listbox show, the first row will disappear when i scroll down…..
again thz in advance

[LJMetzger]

You seem to have duplication of effort. Try removing the lines below from UserForm_Activate():

Please Login or Register  to view this content.

If you have additional problems, please upload a new file, and indicate the exact keystrokes required to demonstrate your problem.

[carlrubber]

but it still in format dd/mm/yyyy please....