Function: Stock calculation with decimals

Adil Kh
Adil Kh used Ask the Experts™
Hello @Saqib Husain, Syed hello everyone,

I am refering to the genius solution of Saqib Husain, Syed concerning the stock calculation
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
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

    Dim qty As Integer


    Dim qty As Single


Thank you Saqib Husain, Syed thank you all


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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial