Can't get excel vba function with two arguments to work

Question

I have this function in Excel Vba:

Function split_std(cell As String, separator As String)

    Dim arr() As String
    arr() = Split(cell, separator)
    MsgBox (arr(0))

End Function

And I am calling it this way:

Sub split_standard()
Set cell = Application.InputBox(Prompt:="Please select the cell to split", Title:="Cell Selection", Type:=8)
separator = InputBox("Please type in the separator of the items in the string")
Dim arr() As String


MsgBox (cell)

split_std (cell, separator)

End Sub

But when finishing writing the call to the function, error: "Expected: =" appears. I already tried by removing brackets, but I can't get it to work. Help please!

VirtualMichael · Accepted Answer · 2017-08-10 23:56:45Z

1

Try this instead:

Function split_std(cell As String, separator As String)
    Dim arr() As String
    arr() = Split(cell, separator)
    MsgBox (arr(0))
End Function

Sub split_standard()
    Dim cell As String
    Dim separator As String

    cell = Application.InputBox(Prompt:="Please select the cell to split", Title:="Cell Selection", Type:=8)
    separator = InputBox("Please type in the separator of the items in the string")
    MsgBox (cell)

    Call split_std(cell, separator)
End Sub

edited Aug 10, 2017 at 23:56

answered Aug 10, 2017 at 23:50

VirtualMichael

7319 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tim Williams · Accepted Answer · 2017-08-10 23:56:05Z

0

Close:

Function split_std(cell As String, separator As String)

    Dim arr() As String
    arr() = Split(cell, separator)
    MsgBox (arr(0))

End Function


Sub split_standard()

    Dim cell As Range, separator As String

    Set cell = Application.InputBox(Prompt:="Please select the cell to split", Title:="Cell Selection", Type:=8)
    separator = InputBox("Please type in the separator of the items in the string")
    Dim arr() As String

    MsgBox cell

    split_std CStr(cell.Value), separator

End Sub

answered Aug 10, 2017 at 23:56

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Collectives™ on Stack Overflow

Can't get excel vba function with two arguments to work

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related