When creating a Listbox in excel using the validation option, does anyone know how to change the format of the text in the listbox. Ex. default is set to ...

The following example adds and deletes the contents of a ListBox using the AddItem and RemoveItem methods, and the ListIndex and ListCount properties. To use this example, copy this sample code to the ...