6diegodiego9
Board Regular
- Joined
- Jan 9, 2018
- Messages
- 80
- Office Version
- 2016
- Platform
- Windows
I see that MrExcel has a color scheme for VBA code that differentiates True/False bollean values and numeric values, like in this example where they are in bordeaux color:
However I can't find an item in the color Options to differentiate them:
I'd like to convert my VBE colors to those of MrExcel VBA code.
Is it possible?
VBA Code:
Sub CSV_Import()
Dim dateien As Variant
Dim i As Long
dateien = Application.GetOpenFilename _
("csv-Dateien (*.csv), *.csv", MultiSelect:=True)
If IsArray(dateien) Then
For i = 1 To UBound(dateien)
Workbooks.Open dateien(i), local:=True
With ThisWorkbook.Sheets(1)
ActiveSheet.UsedRange.Copy Destination:=.Cells(1, .Columns.Count).End(xlToLeft).Offset(, 1)
End With
ActiveWorkbook.Close False
Next i
End If
End Sub
However I can't find an item in the color Options to differentiate them:
I'd like to convert my VBE colors to those of MrExcel VBA code.
Is it possible?