Ok. I understand. Thanks a lot. I love this newsgroup.



Tom Ogilvy wrote:

Again, if you look at the object browser, you will probably see those are
properties of the control object and not of the listbox itself - such as
rowsource as an example. When the listbox is on the worksheet, the property
is ListFillRange and is provided by the OLEObject. If you can set them,
then I don't see anything to fix. For the events, I am not aware of a fix.