| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
use average in a userform
Hi
How to say TextBox1.Value = Average("A1:A") I know this is wrong so how? thanks Alvin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform to enter values and shown in same userform in list | Excel Programming | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
| Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
| Access from add_in userform to main template userform.... | Excel Programming | |||
Linear Mode
