Custom list - how to include commas?
 

In Excel 2002 (or any version), under Tools, Options, Custom Lists, you can
either manually enter list items (separated by a comma or new line) or
import them. If you manually enter them, the entries themselves cannot
include a comma. However, if you *import* the list, the comma is okay.
I've tried delimiting with a single quote, double quotes, and using no
comma, but Excel breaks up the line at the comma. Is there a way, aside
from importing, to have a comma as part of the custom list entry? TIA,

Mike

How about via a macro?

Option Explicit
Sub testme()
Dim myList As Variant
myList = Array("asdf,qwer", "1234,ertw")
Application.AddCustomList myList
End Sub




Mike wrote:

In Excel 2002 (or any version), under Tools, Options, Custom Lists, you can
either manually enter list items (separated by a comma or new line) or
import them. If you manually enter them, the entries themselves cannot
include a comma. However, if you *import* the list, the comma is okay.
I've tried delimiting with a single quote, double quotes, and using no
comma, but Excel breaks up the line at the comma. Is there a way, aside
from importing, to have a comma as part of the custom list entry? TIA,

Mike

--

Dave Peterson

Perfect! Thanks,

Mike

"Dave Peterson" wrote in message
...
How about via a macro?

Option Explicit
Sub testme()
Dim myList As Variant
myList = Array("asdf,qwer", "1234,ertw")
Application.AddCustomList myList
End Sub




Mike wrote:

In Excel 2002 (or any version), under Tools, Options, Custom Lists, you
can
either manually enter list items (separated by a comma or new line) or
import them. If you manually enter them, the entries themselves cannot
include a comma. However, if you *import* the list, the comma is okay.
I've tried delimiting with a single quote, double quotes, and using no
comma, but Excel breaks up the line at the comma. Is there a way, aside
from importing, to have a comma as part of the custom list entry? TIA,

Mike

--

Dave Peterson