Link to home
Get AccessLog in
Avatar of dnt2009
dnt2009

asked on

EXCEL VBA comparing entereCompose QuestionNeed help asking?Please enter a description for d date and syatem date

Hi,

Please find attached codes that I have put together to list all funds that have been entered by the user today on another list. There are 2 worksheets to analyse. Once completed I need to csv the file.

I have issues with comparing the date entered by the user and the system date.
Given the attached sample, I should get 3 rows of date but I randomly get 1 or 2.
could you please help as I don't understand how to fix this issue.

The macro to use is called "Test_Account_NAV"
Thanks,. I have a couple of other macros and function called by the main macro.
dnt
Macro-codes.txt
TestFund-NAV-prices.xlsx
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

Give a working example that demonstrates the issue.
Explain what to do to see the problem, and what show the expected output.
ASKER CERTIFIED SOLUTION
Avatar of dnt2009
dnt2009

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of dnt2009
dnt2009

ASKER

Needed to work out another solution