Thread: use average in a userform
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Hansen Rick Hansen is offline
external usenet poster
  
Posts: 104
Default use average in a userform
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




Reply With QuoteReply With Quote