Refreshing a combo box...?
 

Hello, we need to work out is this is possible....

TIA for any help!

In a VB form in excel, we would like to use the value of one combo box to
influence the available values of another.

So far we have got it to kinda work; We have made the drop down combo box
place it's value in a cell in a sheet. We have then got a second combo box,
to use the =indirect method, based on the cell that we got the first combo
box to place it's value.

The trouble is, we have to shut down the form and then reopen it for the
combo box to list the new available values.

We need to REFRESH the contents of this combo box on the fly, ie, what code
shall we put behind the _change property of the first combo box to do this.

TIA,

DAN
--
Dan Walters