If I understand properly what you're trying to do (and I think I do), then there's good news: you don't need any VBA for this!
Dave Hawley has a great example of how to do this at his Ozgrid site. You can get it from this page:
http://www.ozgrid.com/download/default.htm
Look for the doanload called ChangingCombo2.zip.