Saving form calculations to tables
Microsoft Excel, Visual Basic for Applications, VBA
I have a simple calculation on the input form a-b. It is calculated on the form but I cannot figure how to save it to the table Question
Microsoft Excel, Visual Basic for Applications, VBA
I have a simple calculation on the input form a-b. It is calculated on the form but I cannot figure how to save it to the table 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
If you're talking about an Excel macro in VBA, the code would be something like:
ActiveWorkbook.Sheets(sheetID).Cells(rowNum, columnNum) = calculationResult
(Where the italic bits you'll need to change as appropriate for your worksheet and script.)
Browse more Questions and Answers on Microsoft Windows and Development.
Looking for relevant Microsoft Windows Whitepapers? Visit the SearchWinIT.com Research Library.
