View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
x taol x taol is offline
external usenet poster
 
Posts: 101
Default in Me.lbx.MultiSelect = fmMultiSelectMulti

yes, I explain....
I have a userform.
the userform has a listbox.
a property the listbox is set following below.
lbx.MultiSelect = fmMultiSelectMulti
when the listbox have 10000 data, the problem has.
when the 10000 data is selected... the slow...
and then press a commandbutton on the form, the event occur.
I want to select all data of listbox, fastly.

*** Sent via Developersdex http://www.developersdex.com ***