Summarize data from refedit contol

[Case250]

Hi all I am new to VBA programing. I want my macro to average a range of values which have been selected by the user with refedit control. Could someone give a quick syntax for such a code?

Thanks

 

[Damon Ostrander]

Hi Case250,

The RefEdit control Value is a text string address of the selected range. This can then be used by the Range property to yield a Range object, which can then be input to the Average worksheet function.

Here's an example line of code:

MsgBox "Average is " & WorksheetFunction.Average(Range(RefEdit1))

This pops up a message box displaying the average of the range selected in RefEdit box RefEdit1.

Keep Excelling.

Damon

 

[Case250]

Thanks so much Damon.
That is exactly what I wanted to know.


Case250