VBA to open a CSV, average data and return the result to textbox in userform

[JackDomino1]

Hi all,

I'm looking to have a button in a userform. Once pressed, allow the user to select a CSV file and open it. The code then needs to take an average of a specified range, for example B2:B14 and report the result in a textbox in the userform. The CSV can then close.

Note, the file directory of the CSV will always be different, so the user has to be able to navigate folders to find the file they require. However, the range "B2:B14" will always be the same, in every file.

Thanks

 

[JackDomino1]

Further thought, the result of the "average" function need not write to the textbox in the userform. If the result of the average could be copied to a cell in "sheet2" of the original workbook, that would be ideal.

 

[Fluff]

Thread closed at OP's request