(Solved) – how to copy the contents for the cells and paste at the cells with Auto complete when typing in drop down list

(solved)-–-how-to-copy-the-contents-for-the-cells-and-paste-at-the-cells-with-auto-complete-when-typing-in-drop-down-list

i try the code at different computer but some can copy and paste some cant , i cant figure it out why .. anyone can help me.
i want to copy the contents at the auto complete droplist cell and paste here or somewhere the contents

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim xCombox As OLEObject
Dim xStr As String
Dim xWs As Worksheet
Dim xArr

Set xWs = Application.ActiveSheet
On Error Resume Next
Set xCombox = xWs.OLEObjects("TempCombo")
With xCombox
    .ListFillRange = ""
    .LinkedCell = ""
    .Visible = False
End With
If Target.Validation.Type = 3 Then
    Target.Validation.InCellDropdown = False
    Cancel = True
    xStr = Target.Validation.Formula1
    xStr = Right(xStr, Len(xStr) - 1)
    If xStr = "" Then Exit Sub
    With xCombox
        .Visible = True
        .Left = Target.Left
        .Top = Target.Top
        .Width = Target.Width   5
        .Height = Target.Height   5
        .ListFillRange = xStr
        If .ListFillRange = "" Then
            xArr = Split(xStr, ",")
            Me.TempCombo.List = xArr
        End If
        .LinkedCell = Target.Address
    End With
    xCombox.Activate
    Me.TempCombo.DropDown
End If

End Sub
Private Sub TempCombo_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
Select Case KeyCode
Case 9
Application.ActiveCell.Offset(0, 1).Activate
Case 13
Application.ActiveCell.Offset(1, 0).Activate
End Select
End Sub

Leave a Reply

Your email address will not be published. Required fields are marked *