PDA

View Full Version : vba hos



phoenixmoto
11-06-2018, 12:12 AM
Here in this code in word as i dont know how to use functions(ex:application.worksheetfunction in excel) i tried to create my own function but it is not working may be function creation is incorrect. so please answer me that is it possible to use something like application.worksheetfunction in word or shouldd we create our own function if so how?




If wow.Value = True Then
Select Case comb
Case "addition"
Call amrit(a, b, c)
Case "subtraction"
Call sam(a, b, c)
End Select
End If
hide
End Sub

Sub sum(a As Variant, b As Variant, c As Variant)
ThisDocument.TextBox10.Value = amrit(a, b, c)
End Sub


Sub minus(a As Variant, b As Variant, c As Variant)
ThisDocument.TextBox10.Value = sam(a, b, c)
End Sub


Public Function amrit(a As Variant, b As Variant, c As Variant) As Variant
amrit = a + b + c
End Function


Public Function sam(a As Variant, b As Variant, c As Variant) As Variant
sam = a - b - c
End Function

macropod
11-06-2018, 12:30 AM
There is nothing like application.worksheetfunction in Word.

phoenixmoto
11-06-2018, 12:43 AM
so how to do addition , subtraction etc in word vba whether we should create own functions? if so please provide code.:yes

macropod
11-06-2018, 02:25 AM
so how to do addition , subtraction etc in word vba whether we should create own functions? if so please provide code.
This is not a free coding forum. Code for addition, subtraction etc. is trivial and you should invest some effort of your own learning such simple things instead of expecting others to do it for you.

macropod
11-06-2018, 01:54 PM
Cross-posted at: http://www.msofficeforums.com/word-vba/40834-vba-word.html
Please read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3