Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which User Form Listbox selection just checked?
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). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which User Form Listbox selection just checked?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which User Form Listbox selection just checked?
On 25 Oct 2005 12:36:31 -0700, baj wrote:
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Print a selection based on checked checkboxes | Excel Worksheet Functions | |||
Filter Listbox in user form | Excel Programming | |||
User form with a listbox | Excel Programming | |||
Adding items to a spreadsheet from a user form listbox | Excel Programming |