Issues with Capcost (Mismatch Type, Run-time Error '13')

[anonymity]

Hi guys, im a chemical engineering student, currently doing a senior work project for my final year, so i decided to use the capcost excel by turton, obtained from the book of Analysis Synthesis and Design of Chemical Processes 5th Edition. However, when trying to input data for 'fan' unit, it gives me the Run-time error '13' , mismatch type. The code highlighted this line in the debuggin section:

grateful for any help, thank you in advance )

 

[Alex Blakenburg]

Can you show us where the tbBaseCost is being calculated and formatted.
The way it looks to me is that there is a space after the comma in the immediate window but not in your form, which seems odd.

I can't tell what time zone you are in, so in case it gives you any ideas the below works for me in terms of having the form value treated as a number.

Sub test_conversion()

    Dim sVal As String
    Dim dVal As Double
    
    sVal = "$ 31, 721"
    dVal = CDbl(Replace(sVal, " ", ""))
    
    Debug.Print "dVal ", dVal
    Debug.Print "Multiply by 10 ", dVal * 10
    
End Sub

 

[anonymity]

sorry for not replying, the problem is solved now , thanks for helping me,
the issue is mainly due to the compatibility of the excel origin region with my region, the origin was set in US, im residing in Malaysia, so i just actually need to set my current region to the US, and badaboom it works, thanks alot tho.