excel vba sort by date

[Niss]

hi everyone,

i'm trying to sort table by Date.
the code is simple but i don'd get the required result:

Please Login or Register  to view this content.

'D1 = 01/08/2017
'the table:
header
01/07/2018
01/12/2017
01/08/2017
01/05/2017
01/04/2017
01/01/2017

what i'm doing worng?
thanks.

[protonLeah]

1. Do not give variables names that look like cell addresses

Inputboxes return character strings to variables, not dates (numbers); so, lookup the CDate function:

Please Login or Register  to view this content.

For the future, code tags are required for all code you post.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[Niss]

1. I took your advice - thank u protonLeah
2. alansidman - sorry my mistake its the first time i'm posting.

back to vba:
tried to use the CDate function & also looking for info' at the web but still dont work.
I looked at the sort menu in at the table & its looke like excel see the variable

dte

as a string...

[YasserKhalil]

Try using CLNG vba function instead ..
If it doesn't work please upload sample of your workbook

[Niss]

tried CLNG & I get dbug
my code:

Please Login or Register  to view this content.

the details are:
dte = 01/08/2017 (insert by the user)
table:
header
01/07/2018
01/12/2017
01/08/2017
01/05/2017
01/04/2017
01/01/2017

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[Niss]

"CDate(DateSerial"... and it working greate!
thank u all for your assistance
& thank u Yasser Khlil for solve it

[YasserKhalil]

You're welcome Niss. Glad I can offer some help for you
Please mark the thread as solved
Regards

[Niss]

hi all,
i open that issue again because the code work great at my laptop but not at my other computer (both excel 2013).
any idea why? or any other solution?
thanks.

[alansidman]

Check your VBA references on the machine that works and then make sure that they are the same for the machine that does not work.

[Niss]

Im not sure I understand, what referances do u mean?