Hi Programmers,

I'm trying build an Excel app. that is user friendly. In a column (C),
a user may enter a nickname. If there is no nickname, then the value
that was in the first name field (B) is auto copied to the nickname
field (such as =B2).

If a user enters a nickname, then deletes the nickname, how can the
underlying formula (=B2) be reapplyed to the cell automatically? Also,
I'm concerned about if the user manually enters a nickname in the last
record, then adds another row manually or with a macro that copies
formulas and formatting to the new row--any formula overwritten would
not be included.

Just curious; thanks,

Arnold