View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Robert Christie[_3_] Robert Christie[_3_] is offline
external usenet poster
 
Posts: 117
Default Macro to add 1 or more days to a date

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:

.