Clickable Cells
Solved
cfn3
Posted messages
33
Status
Member
-
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
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
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.
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.
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
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
Hello,
Everything is explained on this page
https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
Best regards
Everything is explained on this page
https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
Best regards
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
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
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
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
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
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
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
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
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
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