[sanj]

Hi,

I would like some advice regarding an arrays,

I have 2 comboboxes,

A and B

I have a Excel Spreadsheet, that looks like (only a sample shown):

Room ,room1, room2, room3,
Equipment ,equip1, equip1, equip1
,equip2, , equip2
,equip3, , equip3
, , ,equip4

Combobox A will list the room numbers
Combobox B will list the relevant equipment,

e.g. when the user selects room2 in comboxbox A equip1 will be shown in combobox B

when the user selects room1 in comboxbox A equip1, equip2 and equip3 will be shown in combobox B

The Excel spreadsheet is long is there an easy way to do this rather than split everything up, maybe by using multi-dimensional arrays?

Thanks for any advice,

Sanjay