Hope Everyone is all right.
I have searched many forums the fact below that make me stuck. Hope someone here will help me.
I have a Large datasheet. In this datasheet, I want to use input box code to simplify my data entry. But I am unable to do it on my own as I am not an expert. So I need Expert help.
This is the table where the ROW heading is in ROW 8.
In the above table when E column data is entered then an input box opens based on B column value.
if B column value is Debit then the input box opens to ask for "Date of Loan Creation" after the date enter it unload in AQ Cell and will show a message as "Loan Creation date is 18/02/2022.
if B column has Credit or nothing then the input box opens to ask for "Date of Savings Entry Creation" after the date enter it unload in AA Cell and will show a message as "Savings Entry date is 13/01/2022. All Date will be "dd/mm/yyyy"
Hope I am able to describe the fact and someone will help me to ease my data entry.
Thanks in advance.