View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michelle Michelle is offline
external usenet poster
 
Posts: 204
Default Nothing selected in my list box?

Hello, I need to find out if the user has selected anything in my
multi-select1 list box, I am currently using

If lbxHeadings.ListIndex = 0 Then

but that is true if nothing is selected or if only the first item is
selected.

If I set option base1 will that allow me to distinguish between nothing
selected and the first item?

Is there an easier way, as option-base1 will mean a rewrite of lots of my
values throughout too?
Thanks

Michelle