Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
Combo Box Not Refreshing View | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
Refreshing a ActiveX combo box | Excel Programming |