PDA

View Full Version : Overwriting values in excel



alfiecat
02-28-2012, 09:42 AM
Hi,

I'm taking in data from a logger and displaying a value on a userform. I want to wait for n values and then average these values and display the averaged value.

The user will enter the number of 'averaged values' they require in the user form.

I need the VBA to store n number of readings by reading the user inputs value of n and then waiting n readings and displaying the averaged value. Then every new reading, the average value will be for the last n readings and so on.....

Can I do this within VBA code or do I need to write the values to an excel sheet and feed that back into the VBA?

Please excuse me if this is very basic, but I'm on the learning path!

Thanks in advance.

P

mdmackillop
02-29-2012, 01:24 PM
Can you post your code that downloads the data.