I probably need to buy a book that is a good excel programming reference, but in the meantime, can someone provide me with example code (or better yet, example spreadsheet with code), that shows an ActiveX combobox with at least 2 selections, where say the first selection writes "bob" and "mary" to cells B5/C5, and the second selection writes "dog" and "cat".

Once I see an example, I should be able to figure out the mechanics. I'm surprised that after a bunch of surfing, I wasn't able to find something like this anywhere.

Thanks,

David