I am trying to make the list presented in a combo box dynamic based on the
selection of from another combo box. Here is the scenario... I have three
clients each having an associated list of offices. By selecting the client
name in combo box1 I would like the list of offices to change in combo box2.

Assuming I get the syntax right can I use the INDIRECT function to vary the
input range of a combo box. I am sure there is a way to do this using VBA
but I am not a VBA user.