linked values in other sheets

[Boon8888]

Hi, basically I have one sheet in my workbook, that contains summar
information and is called 'Summary'. It has one dropdownlist in it.
would like it to be set up so that if I change the value in m
dropdownlist in my Summary worksheet, that the dropdownlists in m
other sheets also change to this value. But at the same time, th
other dropdownlists should be able to take on a value of their own, an
only change to the value contained in the Summary sheet if it i
changed.

I hope this makes sense.

I have tried just having the formula in my other dropdownlists:

=Summary!E1

where E1 is the cell containing the dropdownlist

This works, but as soon as I change the value in those dropdownlist
independently to something else, that formula is lost.

Any ideas, suggestions or help is greatly appreciated. Thanks,

Joe

 

[Jim Rech]

You have to assign a macro to the Summary dropdown. Something like this:

Sub DropDown1_Change()
Dim NewVal As Integer
NewVal = Worksheets("Summary").Range("A1").Value
Worksheets("Sub1").Range("A1").Value = NewVal
Worksheets("Sub2").Range("A1").Value = NewVal
''Etc.
End Sub


--
Jim
message |
| Hi, basically I have one sheet in my workbook, that contains summary
| information and is called 'Summary'. It has one dropdownlist in it. I
| would like it to be set up so that if I change the value in my
| dropdownlist in my Summary worksheet, that the dropdownlists in my
| other sheets also change to this value. But at the same time, the
| other dropdownlists should be able to take on a value of their own, and
| only change to the value contained in the Summary sheet if it is
| changed.
|
| I hope this makes sense.
|
| I have tried just having the formula in my other dropdownlists:
|
| =Summary!E1
|
| where E1 is the cell containing the dropdownlist
|
| This works, but as soon as I change the value in those dropdownlists
| independently to something else, that formula is lost.
|
| Any ideas, suggestions or help is greatly appreciated. Thanks,
|
| Joel
|
|
| --
| Boon8888
| ------------------------------------------------------------------------
| Boon8888's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=30647
| View this thread: http://www.excelforum.com/showthread.php?threadid=511840
|

 

[Boon8888]

Ok great!, ya, I figured a macro was probably necessary. And thanks fo
the example. My only question now is how to assign this created macr
to the dropdownlist?

Thanks,

Joe

 

[Jim Rech]

How you assign macro depends on the kind of drop down you have. If it's
from the Forms toolbar then right-click it and pick Assign Macro.

If it's from the Control Toolbox then double-click it to jump to the click
event handler code. You can paste the code in there. The double-clicking
will only work if you're in "design mode". If you're not, click the first
button on the Control Toolbox to go into design mode.

--
Jim
message |
| Ok great!, ya, I figured a macro was probably necessary. And thanks for
| the example. My only question now is how to assign this created macro
| to the dropdownlist?
|
| Thanks,
|
| Joel
|
|
| --
| Boon8888
| ------------------------------------------------------------------------
| Boon8888's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=30647
| View this thread: http://www.excelforum.com/showthread.php?threadid=511840
|