Avatar of Adil Kh
Adil Kh asked on

Function: Stock calculation with decimals

Hello @Saqib Husain, Syed hello everyone,

I am refering to the genius solution of Saqib Husain, Syed concerning the stock calculation https://www.experts-exchange.com/questions/29096373/Stock-cost-error.html.
And I want to ask you how to modify the code in order to accept also the quantity as number with decimals; three decimal digits. for example 125,586.  The decimal symbol I have is my Excel software is","  that Saqib Husain, Syed had adapted the code for me.

Please find attached the file

Thank you
Draft1.xlsm
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Adil Kh

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Saqib Husain

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.
See how we're fighting big data
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
ASKER
Adil Kh

Thank you Saqib Husain, Syed thank you all
ASKER
Adil Kh

Hello Saqib Husain, Syed,

I want to ask you about this line of the code
If ctr > 1000 Then End: Stop

Open in new window

What do you mlean by 1000 is it a limit of calculation?

Thank you
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy