Hi all,

Forgive me if this turns out to be too easy, but I've a
nice, little macro that runs based on the value in a cell
from a drop down box. Right now, one has to select the
value, then run the macro. I'm sure there's a way to run
the macro from the drop down selection, but I just can't
figure it out.

Any help would be greatly appreciated.

Thanks a bunch,
Paul

Depends upon what sort of drop-down.

If it is a Forms control, just right-click and assign your macro.

If it is a control toolbox control, create a control Click event and run
your macro in there.

If it is a Data Validation, and you have XL2000 or above, you can use
worksheet change event on the cell and run your macro in there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"pvdalen" wrote in message
...
Hi all,

Forgive me if this turns out to be too easy, but I've a
nice, little macro that runs based on the value in a cell
from a drop down box. Right now, one has to select the
value, then run the macro. I'm sure there's a way to run
the macro from the drop down selection, but I just can't
figure it out.

Any help would be greatly appreciated.

Thanks a bunch,
Paul

In the Worksheet Module:
(Data Validation List) cell is E5


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$E$5" Then
Application.Run Target.Value
End If
End Sub


--
HTH
Roger
Shaftesbury (UK)



"pvdalen" wrote in message
...
Hi all,

Forgive me if this turns out to be too easy, but I've a
nice, little macro that runs based on the value in a cell
from a drop down box. Right now, one has to select the
value, then run the macro. I'm sure there's a way to run
the macro from the drop down selection, but I just can't
figure it out.

Any help would be greatly appreciated.

Thanks a bunch,
Paul