MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changung ComboBox LISTROWS at runtime - not working.


Posted by bill on June 05, 2001 7:16 AM

Help!

I change the LISTROWS property of a ComboBox (FORM) at runtime and it just doesn't ssem to work (or perhaps update).

I've looked for properties such as REFRESH or REQUERY but none seem available.

Ideas?

Thank you.


Posted by bill on June 05, 2001 7:55 AM

OK,

It would have helped if I had reset the ROWSORCE of the ComboBox after after changing the range.

Then, the LISTROWS would have seemingly worked:)

Just love answering my questions...