vba: user input named argument

[andrew12345]

Hi all,
How can I make a user have a choice how to parse csv data from another worksheet: sep comma or semicolon.
I have written the follwing line of code:
Sheets("calc").Range("B2:B" & LR).TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=True, Comma:=True, DecimalSeparator:="."
Now my idea was to have the user enter either "Comma" or "Semicolon" into a variable via an Inputbox which I could then use in the named argument. However, Excel does not seem to accept a variable instead of a named argument, at least I don't know how to code it.


Can someone tell me how to code it, or give me another idea?
Thanks for your suggestions.
Andreas

[whatsup]

Hi Andreas
You will have to convert whatever user is offering as his choice via inputbox to a boolean-variable, to meet this syntax (as example):

Sub InsertOption()
Dim blnsemicolon As Boolean
Dim blncomma As Boolean
 
'Select Comma:
blnsemicolon = False
blncomma = True
 
Range("A3").TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=False, _
        Semicolon:=blnsemicolon, Comma:=blncomma
End Sub

Cheers

[andrew12345]

Thanks Whatsup,

that's exactly what I needed!

Andreas