A ListBox can show the contents of part of a sheet on a
user form, but the results are not very good - loss of
formats, all columns the same width, etc. Is there a way
of showing a range from a sheet and retaining some (or
all) of the underlying format?

Phillip.

Try inserting an Image Control on the user form.
Copy the part of the sheet you want to show.
In the properties window for the Image Control,
paste directly into the "Picture" property.
(Believe me it works)
Set the "Picture Size Property" to Zoom.
Adjust the size of the Image Control.

Regards,
Jim Cone
San Francisco, CA

"Phillip" wrote in message
...
A ListBox can show the contents of part of a sheet on a
user form, but the results are not very good - loss of
formats, all columns the same width, etc. Is there a way
of showing a range from a sheet and retaining some (or
all) of the underlying format?