Which User Form Listbox selection just checked?

[Don Wiss]

I'm using xl2002. I have a User Form with a ListBox. The ListBox's
MultiSelect is set to Multi. I have a ListBox_Change event. Inside this
macro how can I tell which of the selections was the one just checked?

Thanks, Don <www.donwiss.com> (e-mail link at home page bottom).

 

[Guest]

Hi,
Sheet1.ListBox1.List(ListBox1.ListIndex) will give you the last selection
that was checked.
Alok

 

[baj]

Hi,

Isn't it possible to store the listindex in seperate factor everytime
you make a selection ?
In that way you always have the last selection...

Bye Baj

 

[Don Wiss]

Isn't it possible to store the listindex in seperate factor everytime
you make a selection ?
In that way you always have the last selection...

I was thinking of that as an alternative.

The reason for this is one of the selections is Entire State. All the
others are territories. When they pick Entire State I'd like to clear all
the territories automatically. It works, but you can't then click a
territory, unless you unclick Entire State first. But maybe such behavior
isn't so bad.

Thanks, Don <www.donwiss.com> (e-mail link at home page bottom).