use average in a userform
Hi
How to say TextBox1.Value = Average("A1:A") I know this is wrong so how? thanks Alvin |
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 |
use average in a userform
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 |
use average in a userform
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 |
use average in a userform
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 |
All times are GMT +1. The time now is 11:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com