Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box "Selection" Get / Let
I'm using a combo box with style set to only allow choices from the fixed
list. the list is fed in as an array on form loading. Problem: I can't seem to get the syntax to highlight/select/boundvalue to get an initial election to show up instaed of a blank. Also need to be able to reset selection onscreen programatically based on other choices user makes on the form. simple version: Combobox1.list = array(1,2,3,4,5) Combobox1.___________ = 3 ' show "3"selected for initial form User clicks elsewhere on form Combobox1.___________ = 4 'selection should change to show 4 I know I'm missing something simple... Combobox1.value = Combobox1.value + 1 ' syntax works??/ since array is dynamic i have not resorted to testing listindex as it would require a search/match loop that should not be needed?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Center across selection" rather than "Merge cells" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Icon for "Wrap" and for "Centre Across Selection" | Excel Worksheet Functions |