Copy and paste data upon click
Closed
bharathjb29
Posts
3
Registration date
Tuesday 13 February 2018
Status
Member
Last seen
15 February 2018
-
Updated on Feb 13, 2018 at 12:09 PM
Blocked Profile - 15 Feb 2018 à 16:56
Blocked Profile - 15 Feb 2018 à 16:56
Related:
- Copy and paste data upon click
- How to copy data from one excel sheet to another - Guide
- How to copy paste youtube link on android - Guide
- Tmobile data check - Guide
- How to reset safe folder password without losing data ✓ - Android Forum
- Mint mobile data not working ✓ - Network Forum
2 responses
Please understand we are volunteers. We help when you are stuck.
In this case, you need to understand the IF statement.
The syntax for IF is:
So, in cell B2, place your IF code. If the logic test is true, then the True will be presented.
Let us know if you get stuck on this homework, which is what this sounds like.
In this case, you need to understand the IF statement.
The syntax for IF is:
=IF(logic_test,True,False)
So, in cell B2, place your IF code. If the logic test is true, then the True will be presented.
Let us know if you get stuck on this homework, which is what this sounds like.
A cleaner way would be 1 liner:
Your code does not qualify the entry, so any value in any of those will FIRE your routine. You specifically asked to qualify when a value is there, and your entry does not do that! I am confused!
Have fun.
If Intersect(Target, Range("A2:A10")) Is Nothing Then Exit Sub
Your code does not qualify the entry, so any value in any of those will FIRE your routine. You specifically asked to qualify when a value is there, and your entry does not do that! I am confused!
Have fun.
bharathjb29
Posts
3
Registration date
Tuesday 13 February 2018
Status
Member
Last seen
15 February 2018
15 Feb 2018 à 14:48
15 Feb 2018 à 14:48
Sorry its not working....
14 Feb 2018 à 12:13
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean))
If Intersect(Target, Range("A2:A10")) Is Nothing Then
Exit Sub
Target.Copy Destination:= range("B2")
End Sub