ExcelBanter - View Single Post - ListBox Headings

Robots

(Jamie Collins) wrote in message . com...
Here's a suggestion: write a class that takes two listboxes as
parameters and changes the properties of the 'headers' listbox
relative to the 'main' listbox. As you say, it required a bit of
jiggling to get right, so write that class now to save yourself the
bother of all that jiggling next time. Post it here and soak up the
kudos.

Jamie.

--

I had not intended to spend the time as you suggested but anyhow I've
done it!

I have not included the class module here because it is somewhat
lengthy for a posting but am happy to provide it on request.

It does not need the reference to the header listbox as the control is
created on the fly as well as adjusting the data listbox accordingly.

Suggestions for improvement welcome.

Ian