Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto check list box
I have a listbox that automatically generates with a list of all the states.
It is set up for option button (fmListStyleOption) and multi-select enabled. How can I select all of the states by default, given the user to option to remove if necessary but not need to add if they want to go nationwide? Thanks in advance. -- Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto check list box
Paul
Add this to your initialize event after populating the listbox Dim i As Integer For i = 0 To ListBox1.ListCount - 1 ListBox1.Selected(i) = True Next i Regards Rowan "Paul" wrote: I have a listbox that automatically generates with a list of all the states. It is set up for option button (fmListStyleOption) and multi-select enabled. How can I select all of the states by default, given the user to option to remove if necessary but not need to add if they want to go nationwide? Thanks in advance. -- Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto fill or auto search from a list or drop-down list??????? | Excel Discussion (Misc queries) | |||
check book auto increment | Excel Worksheet Functions | |||
Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) | |||
Auto Spell Check | Excel Discussion (Misc queries) | |||
Auto spell check as in word | Excel Discussion (Misc queries) |