L
Legacy 237453
Guest
Hi
I have the below code... I want to make it easyier for a user to be able to copy the values in each cell rather than highlight, right click then copy...
Is there just a way that they can click the cell and it will automatically be copyied?
Thanks Alot
Craig
I have the below code... I want to make it easyier for a user to be able to copy the values in each cell rather than highlight, right click then copy...
Is there just a way that they can click the cell and it will automatically be copyied?
Thanks Alot
Craig
Code:
Private Sub worksheet_Selectionchange(ByVal Target As Range)
Set Target = Range("F4")
Range("F10").Value = "ls -lrt *" & Target.Value & "*"
Range("F12").Value = "more X" & Target.Value & ".err"
Range("F17").Value = "ls -lrt *" & Target.Value & "*"
Range("F18").Value = "Now you will see a file called perl s_" & Target.Value & ".pl to launch it copy and paste the below command"
Range("F19").Value = "perl s_" & Target.Value & ".pl"
Range("F22").Value = "ls -lrt *" & Target.Value & "*"
Range("F23").Value = "You should have the result….. *" & Target.Value & "* not found"
End Sub