Would a formula such as =IF(B1="Fred","Barney","") work for you? (assuming
your cell to be checked to be B1)

"Noemi" wrote:

Hi
How do we add into VBA a code to insert a name into a cell when another cell
has a specific word selected from a validation list.

Any help would be appreciated.

Thanks Noemi