Hi All.

New to this forum.

I have a userform where the user must fill in the odo meter reading of his trip. Start reading and end reading. This is then sent to the spreadsheet where these readings are used to calculate the trip distance.
I always only used the spreadsheet and filled it in manually. I only got introduced to UserForms recently. This, for me is the next best thing since sliced bread. My formula used to work pretty well, but since I started to use the userform, the value from the TextBox is entered as text and not a number. This causes the formula not to calculate.

Below is a extract of the code that I'm using.
Range("P26").Value = Format(Me.cbESN, "# ##0")
Please help me.