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
VB ScriptMicrosoft ApplicationsMicrosoft Office

Avatar of undefined
Last Comment
dnt2009

8/22/2022 - Mon
Hamed Nasr

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
dnt2009

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
dnt2009

ASKER
Needed to work out another solution
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck