MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing InputRange on DropDown ListBox


Posted by Walt on October 29, 2001 6:10 PM

I understand how to assign a static InputRange at design time on DropDownBox.

Is there a way to dynamically assign a new InputRange during runtime? If so, what is the correct syntax?


Posted by Mark on October 30, 2001 5:39 PM

I am certainly not a guru at this - but I was able to come up with something that worked for a similar situation. I did not change the InputRange - but I did change the data in the input range by having the data in the InputRange be a VLOOKUP with a series of possible Input Data. Then, if you choose the 3rd data list, you could VLOOKUP column 3 and have this data show up in your DropDownBox.