General information
Category:
Coding, syntax & commands
Title:
Array and listbox help
Have a combo1 that has a rowsource of an array. Also have a two column list1 that has more detail about the selected combo1. Each selected combo1 can have a different number of rows in list1. Trying to get a handle on the array(s) to have as the controlsource of these two controls and how to change the controlsource of listbox1 when combo1 changes.
combo1 list1
----- -----
Table ethan allan, 4
thomasville, 3
Chair watson, 3
Desk office depot, 7
office depot, 8
office depot, 10
want the ethan and thomasville info in the list1 when table is selected in the combo1. getting all confused about the array(s) needed for the controlsource and how to reference the array(s) in the controlsource.
thanks
brenda
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only