Converting VBA output to Number

[MickAtActuarial]

My problem is as follows:

I use user forms (VBA) to assign a number to variable i.e. variable = ClaimAmount, number = 1000, which is then sent to a report and a database. When I use that number in calculations using formulae, for e.g Sum, then results is wrong.

The problem is that the number is stored as text, hence I need a way to convert it to number, so that I can make my calculations work.

Please help.

Thank you

Michael

 

[BrianB]

Excel is quite good at conversions. So ...

'- top of module
Dim ClaimAmount as Integer  ' or Double etc.
'in code below somewhere
ClaimAmount=TextBox1.Value