Thread: Which User Form Listbox selection just checked?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alok Alok is offline
external usenet poster
  
Posts: 318
Default Which User Form Listbox selection just checked?
Hi,
Sheet1.ListBox1.List(ListBox1.ListIndex) will give you the last selection
that was checked.
Alok

"Don Wiss" wrote:

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).

Reply With QuoteReply With Quote