If Date Enter in specific column then input box open to enter number of the same row data enter

  • Hi, Hope all are fine.

    I looking for a code for the below problem.

    The fact is

    If I enter a date in any cell of L9 to L1200 then an input box pops up asking for the number of days. If I give a number then the number unloads in "AP" column to the same row where date entered

    A message will show that number unloaded.

    If I reject the input box then no data unload message shows.

    Thanks in Advance

  • See if you can fit this macro in your project; needs to be pasted in the sheet's module.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!