Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Friday, 02 August 2019
  3 Replies
  6.3K Visits
0
Votes
Undo
I am using the following VBA code to allow for autocomplete when typing in drop down list by using a combo box.

This code disables the "Undo" and "Redo" functions on the sheets that the VBA code is applied to. Can the VBA code be modified to allow these functions?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Update by Extendoffice: 2018/9/21
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
2 years ago
·
#1985
0
Votes
Undo
Was this ever resolved? I am having the same issue
2 years ago
·
#1986
0
Votes
Undo
Was this question answered? I am having the same issue and really need the undo function. 
2 years ago
·
#1987
0
Votes
Undo
Hi Nextgen,

Sorry that you cannot undo or redo after apply any VBA codes. If you want to use the undo or redo function, please use Kutools features.

Amanda
  • Page :
  • 1
There are no replies made for this post yet.