Control Button

**loner2003** · 10-04-2010, 04:02 PM

I'm hoping this is an easy one for someone. I am trying to make a control button selection default to another control button's selection. See example spreadsheet. In the example, I'd like the selection of "State" on the first tab, Input 1, to automatically be the starting selection for the button on tab Input 2. So if I select Indiana on Input 1, I would like the button on Input 2 to default to Indiana. However, i would like the selection on Input 2 to still be able to be changed - I don't want it to statically default to the selection made on Input 1. I'm merely trying to give the list on Input 2 a starting place. Does anyone know how I can get this done?

**Palmetto** · 10-04-2010, 07:28 PM

You can use just one list of states. Set the linked cell for both controls to the same cell. Each control will mirror the selection made in the other one.

**loner2003** · 10-05-2010, 08:20 AM

If I only use one list of states, that means that both selections will always be the same. I need to be able to have them stand independently of one another. For instance, I choose Indiana as the state on the first tab. I would like the second tab to default to Indiana, but I would like the user also to be able to choose another state on the second tab without changing the selection already made on the first tab.

The selections will always be made in the same order - tab one first, then tab two. I'm trying to give the user a starting point for the selection to be made on the second tab as 95% of the time they will be the same. But because of that other 5% of the time, I need to be able to have the control on the second tab stand independently of the first one.

Hope that clears it up a little more. Any ideas?

**Palmetto** · 10-05-2010, 12:02 PM

Get rid of the controls and use Data Validations Lists in the selection cells on both sheets.
Create a named range for the list of states and use this name as the list source for both validation lists.

On Input Sheet1, copy this code to the sheet module. When a selection is made it will set Input2 sheet, cell B5 to the same value, but still allow the user to make a new selection without affecting Input1.

Please Login or Register  to view this content.

**loner2003** · 10-05-2010, 01:46 PM

Thanks Palmetto. I'll give it a shot. If the spreadsheet I'm working with were my creation, I wouldn't have the control buttons. But the one I inherited does, so I'm having to work with what I got. I appreciate your help.