Input box on click of drop down and update cells - EXCEL

Display input box when a value is selected from drop down and replace existing cell values with input from user. Check out the video for very simple method to achieve this! 

If you missed how this feature can be used, you can refer the below video: https://www.youtube.com/watch?v=nJf-c... ---------------------------------------------------------------------------- Also, check out an amazing and easiest way to track files. No more missing corporate files - https://www.youtube.com/watch?v=nNX48... ----------------------------------------------------------------------------- Dont forget to subscribe :) https://www.youtube.com/channel/UC-iW... ------------------------------------------------------------------------------ VBA code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 18 And Target.Value = "RESCHEDULED" Then Dim schedule As Date Dim SDate As String Dim IntDate As String Dim LValue As String LValue = Format(Date, "dd/mm/yyyy") schedule = DateValue(Target.Offset(0, -5).Value) SDate = Format(Target.Offset(0, -5).Value, "dd/mm/yyyy") IntDate = Format(Target.Offset(0, -3).Value, "dd/mm/yyyy") Target.Offset(0, 16).Value = Target.Offset(0, 16).Value + " , " + LValue + "- Rescheduled: Assessment from " + SDate + " &" + " Interview from " + IntDate Set DateCell = Target.Offset(0, -5) Set DateCellInt = Target.Offset(0, -3) frmRescheduled.Show schedule = DateValue(Target.Offset(0, -5).Value) ElseIf Target.Column = 18 And Target.Value = "CLOSED" Then End If End Sub