View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marvin Buzz Marvin Buzz is offline
external usenet poster
 
Posts: 21
Default Listbox Initial Values

I have two listbox controls named FROM and TO
The rowsource for both is the same, but variable in length. When the user
form loads, I would like to have FROM display and select the first value in
the rowsource, and to have TO display and select the last value in the
rowsource. Using TOPINDEX causes the correct value to be displayed, but the
returned value is null.

Any suggestions please?

Thanks.

Marvin