ComboBox and Option Buttons

I have a workbook with a table on Sheet 4 with 12 columns of data and a ComboBox and Radio Button on Sheet 2.

I’d like the ComboBox to list the cities from the first column of data from the table (this should also be dynamic as rows of data are added to the table). I’d then like to know how to populate cells with the data from the rest of the row as selected by the ComboBox choice. The attached example is set up for cells T14-W22 to receive the data.

Secondarily, the Option Buttons should operate alternately to select a subset of the same row of data, either the High or Low values (as shown in the table), and these values would be used to populate a second set of cells, set up in cells D23-D29 in the example attached.

ComboBoxandOptionButtons.xlsm

This will populate your ComboBox on the first sheet based upon the states on the second sheet. It will update whenever you add a new state. Put the code in the worksheet change event for the second sheet. I ran out of time and was not able to work on the other stuff. Maybe I will have more time this weekend.

Please Login or Register  to view this content.

This worked out well so far.

Here is the rest of it. It wasn't clear how the radial buttons would factor in so I just utilized whatever their values was when the ComboBox changes. IMPORTANT: YOU MUST UNMERGE CELLS T14-W22!!!!

Please Login or Register  to view this content.

This is great and I really appreciate the work involved. This worked out just as I needed it to. I added this code to the option buttons click event too so the values change with the buttons and not just with the ComboBox. Now, if only I could get merged fields to update...I have removed the merge settings and it works great, so it looks like I just need to tweak some of the other fields around them so I can have the centered look I'm after, but otherwise this is exactly what I needed.

Thanks again...