Hi keepitcool
You guys amaze me.
Once more a positive answer to a question.
I believe every reasonable question I have ever asked
this group has been replied to in the positive.
Is the rumour true Excel can even float on water. ( :-)
(v vbg).
I thank each of you once again.
keepitcool
JE McGimpsey
Chip Pearson
Thankyou
Regards Bob C.
-----Original Message-----
You could have 1 eventhandler to handle several target
cells.
I'm typing this.. code shows the idea etc..
sub Before_RightClick(byval target as range)
select case target.address
case "$A$1", $C$3: call Dateclicker1(target)
case "$e$7", $f$8: call Dateclicker2(target)
Case "$D$3" : call NameClicker(target)
end select
end sub
sub Dataclicker1(tgt as range)
target=target+3
end sub
etc
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool
"Robert Christie"
wrote:
.