Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to program multi-select list box?
Hi all,
I am a begginer in programming Excel forms, and I ran into an issue I don't know how to resolve. Please help! I have a multi-selection list box, and I use "on Change" event to do some things whenever user changes selections. It works fine, but I have problem initializing the list. When the form is activated, I want to restore the selections saved when a user closed the form. So I go item by item and set their "Selected" status according to the status array I saved on exit. However, every time it triggers "Change" event, and everything gets screwed. Is there a way to turn-off the Change event while manupulating control values programmatically? Or have the control to react only on changes casued by the user? Or maybe I am taking a completely wrong approach? Thanks! RADO |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi-select from a dropdown list | Excel Discussion (Misc queries) | |||
Multi Select from Drop List | Excel Discussion (Misc queries) | |||
how do I select multi values from a list | Excel Discussion (Misc queries) | |||
Extract values from a multi-select multi-column list-box | Excel Programming | |||
Multi Select List Box | Excel Programming |