Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#

Download:

Datei 1: Demo_30a_Excel_Formel_Function_english.xlsm

 

 

Example how to calculate complex formulas in Microsoft Excel

 

Tutorial

 

 

 

Option Explicit On

 

Public Function Test(Input_cell As Range)

    Dim sText As String

    sText = Input_cell.Value

 

    Test = sText & "... something"

End Function

 

 

Public Function code_formula(Input_cell As Range)

    '---------------< code_formula() >-----------------

    'code_formel = In_Zelle.Formula

    Dim input_Value As String

    input_Value = Input_cell.Formula

 

    '< output >

    code_formula = "=" & input_Value & "      calculated in macro functions.  " & " from cell(" & Input_cell.Address & ")  "

    '</ output >

    '---------------</ code_formula() >-----------------

End Function

 

 

 

 

 

Public Function my_Calculation(In_Zelle As Range)

    '---------------< my_Calculation() >-----------------

    Dim my_Value As String

    my_Value = In_Zelle.Formula

 

    '< calculation >

    Dim dblZahl As Double

    dblZahl = CDbl(my_Value)

    dblZahl = dblZahl * 100

    '</ calculation >

 

    '< output >

    my_Calculation = dblZahl

    '</ output >

    '---------------</ my_Calculation() >-----------------

End Function

 

 

Mobile
»
Excel : Convert numbers to text
»
Excel function: find the position in a column or row
»
Excel: Find text in a value
»
Excel: Count how often a value occurs
»
Excel Exponent Numbers
»
Excel: Text Like function
»
Excel: Determine a substring from text with Formulas
»
Excel: Barcode by Excel Insert macro code into cells
»
Excel Macro Formulas for calculation
»
Excel: Enter values ​​from your own function formula

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de