Ok...

I am trying to make a text box (aptly named txtCalc) to show a
calculation between another txt box (txtAmount) and a cell that exists
in the spreadsheet behind the form. The calculation will show a bank
balance preview.

For example the cell that is mentioned above is Cell F1 and contains a
figure of £9000

In the userform, the user enters a transaction of - £500 in txtAmount
field. thus the txtCalc area automatically shows a figure of £8500.
This figure does not have to go onto the spreadsheet (but can if
needed).

How can this be done...

Cheers (much in advance)

Jamie