Creating mean, median, mode and range calculator in userforms

[mr vba]

Hello i
Am trying to create an excel mean median mode and range calculator in userforms

I have set out the form and it looks like this]

The idea is you select what you want to calculate and enter the range of numbers and it enters the answer in TextBox 2 at the bottom.

So far haven’t managed to find any formulas and I am not very skilled in vba

 

[Anthony47]

You can use Application.WorksheetFunction.WhichFunction(function sysntax) to exploit within vba the excel functions and get the result...

 

[mr vba]

How can i use that in a code sequence so the function answer goes into the second textbox?

 

[Anthony47]

For example, within the CommandButton_Click code:

If Me.ComboBox1.Value = "Mode" Then
    On Error Resume Next
    Me.TextBox2.Text = Application.WorksheetFunction.Mode(Range(Me.TextBox1.Value))
    On Error GoTo 0
ElseIf Me.ComboBox1.Value = "XYZ" Then
    'your instructions for the function
ElseIf Me.ComboBox1.Value = "ABC" Then
    'your instructions for the function
'etc
'etc
End If

I used "On Error" as a poor man error handling procedure, you'd better check that the parametres for the selected function are properly selected and issue proper error messages to guide the user in the process

Bye