View Single Post
 
Old 11-18-2014, 07:45 AM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

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):
Code:
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
Reply With Quote