View original (French)

Clickable Cells

Solved
cfn3 Posted messages 33 Status Member -  
cfn3 Posted messages 33 Status Member -
Hello everyone,
Hello eriiic
I tried this piece of code for the clickable cell, and indeed it works very well. It adds a little extra to my limited knowledge.
I would like to use it for player marking; I need at least 2 clickable cells on the same sheet. In this case, what would be the solution?
Thank you in advance for your help
Best regards
Noel

10 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    I have no idea what you're talking about...

    Upload the xls file (reduced to the necessary and anonymized, with explanations and possibly the expected result) on cjoint.com and paste the provided link here.

    eric

    --
    You will never respond to an unsolicited private message...
    Well, that's done.
    0
  2. cfn3 Posted messages 33 Status Member
     
    Hello Eric,
    I would like to attach the small file but I don't know how to do it. I couldn't find a link to add a file.
    Can you provide me with the solution to attach a file?
    For now, I've sent you the file via the "Reply" of the email.
    Talk to you later
    Best regards
    Noel
    0
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Can you provide me with the solution to attach a file.
      It's written in my previous post...
      eric
      0
  3. cfn3 Posted messages 33 Status Member
     
    Hello everyone,
    Hello Eric,
    I am really sorry for not being able to find a way to attach my file.
    While searching the site, I found this in a post: https://www.cjoint.com/ .
    It's the same, but I don't know how to send it to you.
    Thank you for your help
    See you later
    Best regards
    Noel
    0
  6. cfn3 Posted messages 33 Status Member
     
    Re,
    Hello PapyLuc51,
    Thank you for giving me the link to attach a file.
    I’m not sure if I followed the instructions correctly.
    Eric, here is the link for the file; which one is the right one, I'm not too sure, but I tried.
    https://www.cjoint.com/?3HkhJXL7FM9
    https://www.cjoint.com/
    I think the first one is the right one. I even tried it.
    Thank you both for the upcoming solutions.
    @+
    Best regards
    Noel
    0
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      why don't you explain your problem and what you want in detail?
      eric
      0
  7. Frenchie83 Posted messages 2254 Status Member 339
     
    Hello cfn3, hello Eriiic

    I believe cfn3 wants to run several counters on the same sheet

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Cells = Range("E11") Then
    If Intersect(Target, [e11]) Is Nothing Then Exit Sub
    [c11].Value = [c11].Value + 1
    Cancel = True
    ElseIf Target.Cells = Range("E24") Then
    If Intersect(Target, [e24]) Is Nothing Then Exit Sub
    [c24].Value = [c24].Value + 1
    Cancel = True
    End If
    End Sub

    Have a nice day
    0
  8. cfn3 Posted messages 33 Status Member
     
    Re
    Hello Frenchie83,
    That's exactly what I wanted. Frenchie has understood my problem well, which I thank in passing.
    For the moment, I don't have time to try this piece of code, as I prefer to respond to the people who have replied to me.
    I think I will be able to try that by Monday, and I will keep you updated on how it goes.
    In any case, thanks to Eric, Papy, and Frenchie for your help.
    Wishing you a great weekend
    @+
    Best regards
    Noel
    0
  9. cfn3 Posted messages 33 Status Member
     
    Hello everyone,
    Hello Frenchie,
    the piece of code you sent me gives me a compilation error: EndSub expected. I tried to look, there is an end of code but I don't understand why it's giving me this response.
    Thanks for checking why and keep me updated.
    Best regards
    Noel
    0
  10. Frenchie83 Posted messages 2254 Status Member 339
     
    Hello

    Weird, it's working very well for me, except that I fixed a small anomaly that didn't generate any errors.

    To make sure I have the same thing, I'm sending you the file again

    in Excel 2000 format: https://www.cjoint.com/c/CHlg6BVzflv
    in Excel 2007 format: https://www.cjoint.com/c/CHlg7vSQtU0

    they are the same, except that the file extension is different
    Let me know if it works correctly
    Have a nice day
    0
    1. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 512
       
      Hello,

      it's the opposite for your links, 2007 is listed first

      best regards
      0
    2. Frenchie83 Posted messages 2254 Status Member 339
       
      Hello

      thank you for this remark

      have a nice day
      0
  11. cfn3 Posted messages 33 Status Member
     
    Re,
    Hello PapyLuc,
    Thank you to the three of you, it works very well. I think the "$" was missing.
    I will certainly still need your help, as I often program in Userform.
    Thanks again, Reunion is waiting for you with open arms.
    See you soon
    Best regards
    Noel
    0