One way would be to apply the CStr function to each value of the ListBox as
you use it. For example

Range("A1") = CStr(ListBox1.Value)

Or if MultiSelect

Range("A1") = CStr(ListBox1.List(0)

The CStr function forces the data to string type and if it is already string
type it ignores it.

"Beancounter" wrote in message
...
I have a userform list box - the data it is using to populate the list
box contains part numbers - some of which are text and some of which
are numbers. How do I set it so no matter what type of part number is
selected, it will show as text?

Thanks in advance.