Thanks
its working

Alvin


"Norman Jones" wrote:

Hi Alvin,

Try:

TextBox1.Value = Application.Average(Range("A1:A10"))


---
Regards,
Norman



"alvin Kuiper" wrote in message
...
Sorry don't work
get a error in the line
alvin


"Rick Hansen" wrote:

Hi Alvin,

Try
TextBox1.value = WorksheetFunction.Average("A1:A10")

HTH
Rick


"alvin Kuiper" wrote in message
...
Hi

How to say
TextBox1.Value = Average("A1:A")
I know this is wrong so how?
thanks
Alvin