asked on How to convert a excel formaul in vb 6.0 function
excel formula : C15*(1+$B$10)^(A16-A15)
1000 * (1+3.15%)^(1)
Excel result: 1,032
Not sure how to use it in visual basic 6.0
Cheers
1000 * (1+3.15%)^(1)
Excel result: 1,032
Not sure how to use it in visual basic 6.0
Cheers
Visual Basic Classic
Last Comment
RIAS
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Cheers mate
Sub UseFunction()
Dim myRange As Range
Set myRange = Worksheets("Sheet1").Range
answer = Application.WorksheetFunct
MsgBox answer
End Sub
for more : click here
For the above example you have to use formulas such as SUM, PRODUCT et al
The list of available formulas click here.