Display Decimal value in text box ?

Hi,
i am pretty new in VBA, and i am blocked in my program while i attempt to display a

decimal value in a text box.

For instance :

i have a spreadsheet showing the percentage of completion of cables installation. I want to

COUNT how many cables have been 100% pulled.

Then i divide this value by the total of cable to get the % of total cable pulled for the

project.

When this value ( CablesPulled) is divided with a number giving a 0.xxxx value, the result

is always 0 in the text box.

If for instance, i divide by six, it shows the integer number, not decimal value.

844 / 6 = 140 ( instead of 140.66) 844/1200 = 0 ( instead of 0.70)

I think i have to format the text box value but i am not sure how.

I tried different resources ( excel help, books...) but i can hardly find something treating

this problem .

This is a portion of my code :

Please Login or Register  to view this content.

Thanks all for your expertise.

You are referencing the wrong variable. Don't use "CablesPulled", use "Total"

Please Login or Register  to view this content.

Try using type Double, without converting to sub-type Decimal.

Please Login or Register  to view this content.

Hello Breizh29,

Welcome to the Forum!

There are a couple of problems here. First, you used integer division instead of floating point. the backslash "\" is used in VBA to divide and return an integer result. Probably a typo. You need to use a forward slash "/" for floating point division. Second, you do not need to convert to a decimal type. Third your conversion to a percentage needs to be multiplied by 100. This can be done in the Format statement using a percent sign. Here is the corrected code.

Please Login or Register  to view this content.