98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » How do i
How do i
Resolved · Low Priority · Version 2003
Thu 7 Aug 2008, 16:28Delegate Phil said...
Phil has attended:
Excel VBA Intro Intermediate course
How do i
contruct something like a DSUM in VBA - is it possible to perform such a complicated table
Fri 8 Aug 2008, 09:37Trainer Carlos said...
DSUM Function in VBA
Hi Phil
To use one of the Excel functions like DSUM, you need to create a variable to store the DSUM value. The variable type must equal the type of data being returned (In this case Single or Double).
The code would be:
Dim MyDSumValue As Single
MyDSumValue = Application.WorksheetFunction.DSum(Database, Field, Criteria)
Hope this helps
Carlos
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Paste a web address into the hyperlink address fieldIf you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work. |
