I'm currently upgrading my company's travel expense report. As a rule, I
require all employees to provide name(s) and topic of discussion when
entertaining a customer/co-worker. Well, this rule is often violated
requiring me to follow-up with the employee to obtain the necessary info. Is
there such a macro (i.e., msgbox) that would automatically request for this
info immediately after the user populates a particular cell? In other words,
let's say the user enters $50.00 in a cell that corresponds to the row for
"Customer Entertainment Expenses". I'd like for some sort of questionairre
to pop-up that requires the user to complete before they can continue.
Moreover, I'd like for his answers to pop-up on different section of the
worksheet. If the user leaves blank, the amount is rejected. Tall order,
huh!?