| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
| Paste from Word table so that 1 table cell = 1 Excel cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
