Sum Columns in MS Office Spreadsheet Control
Posted on 2009-05-14
I have a form (Form1) in MS Access that contains an MS Office Spreadsheet Control titled "Spreadsheet0". I want to add Text Boxes above the Spreasheet Control that show the total for each spreadsheet column. So the Text Box named TextBox1 would show the total for Column A in the Spreadsheet, etc, etc.
If I was working in Excel with a Userform that contained a Text Box, I would use somthing like: WorksheetFunction.Sum(Columns(1)). However, WorksheetFunction appears to not work with the Spreadsheet Control in MS Access.
How do I show the sum of the numbers in Column 1 of the Spreadsheet Control in TextBox1?