Hi Nigel

Txtid.Text = Range("A1").Formula

HTH. best wishes Harald

"Nigel" skrev i melding
...
i have a userform. on the form is a text box called txtid. i need it to
show
content of a formula as follows: =counta(A1:A1000)+1. can anyone help me?
i can email the workbook if needed.

regards,

nigel