Summarize data from refedit contol

Case250

Board Regular
Joined
Oct 4, 2006
Messages
54
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
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
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

Board Regular
Joined
Oct 4, 2006
Messages
54
Thanks so much Damon.
That is exactly what I wanted to know.


Case250
 

Forum statistics

Threads
1,175,985
Messages
5,900,731
Members
434,846
Latest member
darksider_hp9x

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top