show name when a cell has specific word
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 |
show name when a cell has specific word
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 |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com