In a spreadsheet of Excel, I placed a combobox that shows a range of cells from another sheet (Sheet_Ex)in the same workbook. I have two other Textboxes that show a different range of cells also from Sheet_Ex. How can update my last two textboxes based on what I chose in the combobox? So if the combobox shows all the street names and I select a street, how can one textbox show the length of that street and the other textbox show the Width?
I simply used this method to add controls into my excel spreadsheet - http://techonthenet.com/excel/questions/create_combo.php
Can I continue with that method or do I have to actually make a UserForm and update it?