hello eveyone.
im trying activate a macro when a cell is selected.
for example:

i have a range of cells a1 d10.
if any cell within this range is selected i would like for a macro to be run automatically.

when cell is selected a box would come up with options of selecting 1-6.
value of selected cell would copy to cell assign to option.

1=a20
2=a21
3=a22
4=a23
5=a24
6=a25

thanks

This took me about 2 days to find it out

here is the trick
ALT+f11 get the VB thing
the in Excel Objects
double click on the said sheet

change the drop down boxes to worksheet and Change

you show see a

Private Sub Worksheet_Change(ByVal Target As Range)


End Sub

what I did was create a select case on the Target

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address

CASE "$D$10"
call that_other_sub
Case "$E$16", "$E$17", "$E$18", "$E$19", "$E$20", "$E$21", "$E$23"
call and_other_sub
case else
end select
End Sub

you make you user very happy when you get it working

thanks for replying.
i tried this but wont even run anyone with any suggestion?
thanks

this is a start.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then <---i need this to be a range a1:g10
MsgBox "Cell " & Target.Address & " has changed."

End If
End Sub

what happen

I found this

excel - VBA test if cell is in a range - Stack Overflow

and tested it it work

Here the file I created base on the that link

it a nice trick MMMM think i can use this on my own staff