[Solved] define an input suggestion with vba in excel

by


You could you a simple userform to select and parse data selection into the row you clicked.

First use an Event when you click in the column you want the reminder to pop up in. In this case I choose “D”.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim arr
    If Not Intersect(Target, Range("D:D")) Is Nothing Then
      Application.EnableEvents = 0
          UserForm1.Show
          Target = a
      Application.EnableEvents = 1
    End If
End Sub

Then load the user form with your reminder data and select the reminder data you need from a userform combobox.

Private Sub UserForm_Initialize()
  Dim arr
    arr = Array("Unit1", "Unit2", "Unit3", "Unit4", "Unit5", "Unit6", _
                     "Unit7", "Unit8", "Unit9", "Unit10", "Unit11", "Unit12", _
                        "Unit13", "Unit14", "Unit15", "Unit16", "Unit17", "Unit18", _
                          "Unit19", "Unit20")
        Me.ComboBox1.List = arr
End Sub
Private Sub ComboBox1_Change()
     a = ComboBox1.Value
     Unload Me
End Sub

And you will need to put a public variable in a standard module to store the data you want pasted in your sheet.

Public a As String

Be sure to change any control names to suit you.

solved define an input suggestion with vba in excel